CODEWITHSUNDEEP
qliksense
Mobin
Mobin

Reputation: 31

How can I found that how many Unique values are in my data set, in Qlik Sense?

I'm have a simple question in QlikSense. I have a data set about website views from various IPs of all over the world, but want to see the output of unique IPs; not all IPs. should I use any functions? If not, so how can I do that one? I'll be happy if you help me. So thanks for your cooperation again.

Upvotes: 2

Views: 891

Answers (2)

Chris J
Chris J

Reputation: 936

If you add IP as a dimension, Qlik Sense will automatically show only distinct values.

However, I recently did something with referring URLs and found I had to do a bit of data cleansing before I could make sense of it. This code might help.

UrlPartsRaw:
lOAD [Page Url]
    ,SubField([Page Url],'/',ITERNO()) AS UrlComponent

    ,ITERNO() as UrlComponentIterNo
RESIDENT WebpageDetailActivity
WHILE(ITERNO()<=SubStringCount([Page Url],'/')+1);

Map_URLClean:
Mapping Load * INLINE [ 
char replace
.com.
.com
.ca
.co.uk
.co
.fr
.jp
.local
.org
.cn
.net
.ru
fanyi.
translate.
webcache.
web.] (delimiter is ' ');

WebParts:
lOAD [Page Url]
    ,MapSubString('Map_URLClean',UrlComponent) as UrlComponent
    ,Replace([Page Url],UrlComponent,'') as UrlPart
RESIDENT UrlPartsRaw
where UrlComponent<>'' and not(isnull(UrlComponent))
and UrlComponentIterNo=1;

Upvotes: 0

alf.cz
alf.cz

Reputation: 59

Try Count(distinct [IP]) -distinct is for unique values

Upvotes: 2

Related Questions