Set Analysis to count number of stores if a store is active (CA>0)

[OmarBenSalem]

Hi folks,

As mentionned in the title, I want to be able to count how many active stores I have (with CA >0)

How to tell QlikView to count only those stores in a set analysis expression?

In sql it would be something like this :

select

Count(distinct stores)

from table

where CA >0

in a set expression, if i write sthing like this:

Count({<CA={'>=0'}>}stores) ; the CA will not be specific to store, it's about all the CA, find that it's >0 and thus the result won't be accurate since I will have all the stores returned even the inactive ones.

I tried with the aggr, and I still get wrong answers.

Anyone could help me please?

Thank you !

[Mark_Little]

Hi,

I would normally do something like this in script and create a flag. Would be similar to what you have above.

Mark

[MK_QSL]

Can you provide 5-6 lines sample data to work?

Try

COUNT({<stores = {"=CA > 0"}>}Distinct stores)

[muthukumar77]

Hi,

Try This,

COUNT({<CA={">0"}>} Distinct stores)

[Anonymous · Accepted solution]

Hi Omar,

Try this:

COUNT({<stores = {"=Count(DISTINCT CA)>0"}>}Distinct stores)

Regards!

[#6]

Try this,

=COUNT({<CA -={0}>} DISTINCT stores)

[aapurva09]

Hi,

Count(Distinct {<CA={">0"}>} Stores). If this doesn't work. Share the data to check the relation between stores and CA.

Thanks.

[OmarBenSalem]

Yes, that's it; thank you all

[Anonymous]

You're wellcome!