Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe like
count({$<Country={'SWE'}, Kundnr = {"=Count(ordernr)>=5"} >} DISTINCT Kundnr)
Something like:
count({<Country={'SWE'}, Kundnr = {"=Count(ordernr)>=5"}>} DISTINCT Kundnr)
or
count({<Country={'SWE'}>} DISTINCT If(Count(ordernr)>=5, Kundnr))
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