topic count as condition inside set in QlikView

count as condition inside set

t_hylander — Wed, 13 Jan 2016 13:54:37 GMT

Hi,

I'd like to sum up customers that have more than 5 orders and lives in Sweden.

Tried to search for a solution but couldnt find how to use Count inside a Count.

This is what i have as of now;

count({$<Country={'SWE'} >} DISTINCT Kundnr)

and I would like to have something like this;

count({$<Country={'SWE'}, Count(ordernr)>=5 >} DISTINCT Kundnr)

Thanks in advance!

swuehl — Wed, 13 Jan 2016 14:08:36 GMT

Maybe like

count({$<Country={'SWE'}, Kundnr = {"=Count(ordernr)>=5"} >} DISTINCT Kundnr)

jonathandienst — Wed, 13 Jan 2016 14:12:14 GMT

Something like:

count({<Country={'SWE'}, Kundnr = {"=Count(ordernr)>=5"}>} DISTINCT Kundnr)

count({<Country={'SWE'}>} DISTINCT If(Count(ordernr)>=5, Kundnr))

VishalWaghole — Wed, 13 Jan 2016 14:29:21 GMT

Hi,

Try below expression, and also find attached sample qvw, hope this will help you

=If(Count(ordernr)>=5,Count({$<Country={'SWE'}>}Kundnr))

Regards,

Vishal