topic set analysis ordered count in QlikView

set analysis ordered count

stephenedberkg — Wed, 09 Dec 2015 07:41:12 GMT

i want to calculate the ordered count .

ex:

ordered

my order count is 3

how to achieve this in set analysis?

Anonymous — Wed, 09 Dec 2015 07:44:57 GMT

may be like:

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

stephenedberkg — Wed, 09 Dec 2015 07:49:10 GMT

thanks for your quick reply

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

ordered

null;

my order count is 3

Wed, 09 Dec 2015 07:50:10 GMT

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

Anonymous — Wed, 09 Dec 2015 07:50:46 GMT

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

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

arulsettu — Wed, 09 Dec 2015 07:51:41 GMT

maybe this

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

ashwanin — Wed, 09 Dec 2015 07:53:44 GMT

Hi,

Please try

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