Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
stephenedberkg
Creator III
Creator III

set analysis ordered count

i want to calculate the ordered count .

ex:

ordered

0

5

6

8

0

my order count is 3

how to achieve this in set analysis?

1 Solution

Accepted Solutions
Anonymous
Not applicable

may be like:

=count({<ordered={'*'}-{'0'}>} disctinct ordered)

View solution in original post

6 Replies
Anonymous
Not applicable

may be like:

=count({<ordered={'*'}-{'0'}>} disctinct ordered)

stephenedberkg
Creator III
Creator III
Author

thanks for your quick reply

its working fine but if my data have null value how to write?

ordered

0

5

6

8

null;

my order count is 3

Not applicable

=count({<ordered-={'0'}>} DISTINCT ordered)

Anonymous
Not applicable

null as a text in your field?? if yes, may be this:

=count({<ordered={'*'}-{'0','null'}>} disctinct ordered)

arulsettu
Master III
Master III

maybe this

=count({<ordered={'*'}-{''}>} disctinct ordered)

ashwanin
Specialist
Specialist

Hi,

Please try

=count({<ordered -= {'0'}>}   ordered)