Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Distinct Count with two criteria at QlikSense

Dear friends,

I need a formula that has a distinct count of Nº Hasta without blanks with another criteria distinct count of Date Hasta as figures below.

Nº HastaDistinct Count of Date Hasta
(blank)123
01/HP/CCM/DP/20151
01/HP/DA/CCM/20152
02/HP/CCM/DP/20131
02/HP/DA/CCM/20151
03/HP/CCM/DP/20141
03/HP/DA/CCM/20151
05/HP/CCM/DP/20131
05/HP/CCM/DP/20141
06/HP/CCM/DP/20141
07/HP/CCM/DP/20141
08/HP/CCM/DP/20142
09/HP/CCM/DP/20131
12/HP/CCM/DP/20131
13/HP/CCM/DP/20132
HASTA N.º 11
HASTA N.º 31
HASTA N.º 51
HASTA N.º 71
Grand Total139

Nº HastaDistinct Count of Date Hasta
01/HP/CCM/DP/20151
01/HP/DA/CCM/20152
02/HP/CCM/DP/20131
02/HP/DA/CCM/20151
03/HP/CCM/DP/20141
03/HP/DA/CCM/20151
05/HP/CCM/DP/20131
05/HP/CCM/DP/20141
06/HP/CCM/DP/20141
07/HP/CCM/DP/20141
08/HP/CCM/DP/20142
09/HP/CCM/DP/20131
12/HP/CCM/DP/20131
13/HP/CCM/DP/20132
HASTA N.º 11
HASTA N.º 31
HASTA N.º 51
HASTA N.º 71
Grand Total21
3 Replies
sunny_talwar

May be this:

Count(DISTINCT {<[Nº Hasta] = {'*'}>} [Nº Hasta])

Not applicable
Author

Instead of Count(DISTINCT {<[Nº Hasta] = {'*'}>} [Nº Hasta]) i change for Count(DISTINCT {<[Nº Hasta] = {'*'}>} [date Hasta]) and it works.

Many thanks

sunny_talwar

Awesome