topic Count distinct in Set Analysis in QlikView

Count distinct in Set Analysis

Fri, 04 Apr 2014 09:57:27 GMT

Hiya,

I'm trying to count a total number of users and a total number of users accessing. I'm using data from Google analytics.

I'd like this to be a KPI so I created two text objects:

Total number of users: Sum(DISTINCT(User))

Total number of users accessing: Sum(DISTINCT{$<visits = {">0"}>} [User])

Any thoughts?

Re: Count distinct in Set Analysis

Gysbert_Wassenaar — Fri, 04 Apr 2014 10:24:45 GMT

Try using the count function:

Count(distinct User)
Count({$<visits= {">0"}>} distinct User)

Re: Count distinct in Set Analysis

Fri, 04 Apr 2014 10:37:23 GMT

Thanks Gysbert Wassenaar that did seem to do something good!

I have added a third box that would display number of users NOT accessing the site using:

Count(DISTINCT{$<visits = {"0"} >} DISTINCT User)

It displays 0 every time I make a selection.

The two boxes (Total no of users and Total no of users accessing) are displaying the same value every time I make a date selection. The first box should give me total number of users for the entire dataset but it doesn't, it only counts users that accessed the site on the date I selected. Any idea how to get that fixed?

Re: Count distinct in Set Analysis

Gysbert_Wassenaar — Fri, 04 Apr 2014 10:47:16 GMT

Add {1} to an expression to ignore all selections: Count( {1} distinct User)

I'm also guessing that there is only data for users for the dates they actually visited. So if you select a date you cannot select users with a visit value of 0 since there is no data for the users you're looking for. If that's correct then you should be able to calculate the number of non-visiting users with count({1-<visits={'*'}>} User).

Re: Count distinct in Set Analysis

pshverma847 — Tue, 03 Sep 2024 03:26:41 GMT

Hello,

Count(DISTINCT {<OCN = {"=Sum(ARRPLUSAUEUR)<=100000"}>} OCN)

My above condition is working absolutely fine, I'm counting the OCNs here where the "ARRPLUSAUEUR"<=100K. Now the problem I'm facing is to give one filter on one of the field in my data and want to restrict the data, but not able to use IF in this condition. Can you please help.

Condition: D_LIFECYCLESTATUSCODE="In Process", This I want to put somewhere in this condition.