topic Re: count sum in set analysis in QlikView

count sum in set analysis

anitamanders — Mon, 30 Sep 2013 12:07:11 GMT

Hello,

I want to count the cusomers (=cddeb) that have a total sales (= omzet-bedr) of >20000<30000 (and so further on)

When I do this:

count

({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb))

the fomula is okay. But this doesn't sum the sales.

When I add sum to the formula:

count

({<sum([omzet-bedr])={'>20000<30000'}>}distinct(cddeb))

it doesn't work any more.

Why?

What do I do wrong?

Can someone help me out.

tresB — Mon, 30 Sep 2013 12:19:36 GMT

Try like:

Count(If(Aggr(Sum(omzet-bedr), cddeb)>20000 and Aggr(Sum(omzet-bedr), cddeb)<30000, cddeb))

swuehl — Mon, 30 Sep 2013 13:02:05 GMT

Try like this

count({<cddeb = {"=sum([omzet-bedr]) >20000 and sum([omzet-bedr]) <30000"}>} distinct cddeb )

Mon, 30 Sep 2013 13:04:43 GMT

count

({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb)) this is correct

({<sum([omzet-bedr])={'>20000<30000'}>}distinct(cddeb)) this is not correct

dont give sum with field name

set analysis exp is like

sum({<[omzet-bedr]={'>20000<30000'}>}distinct(cddeb)) try like this

israrkhan — Mon, 30 Sep 2013 13:09:42 GMT

try this.

count(if({<cddeb = {"=sum([omzet-bedr]) >20000 <30000"}>}) distinct cddeb )

anitamanders — Mon, 30 Sep 2013 13:28:51 GMT

Thank you Swuel,

this works great!

wajiha — Thu, 21 Nov 2019 08:50:40 GMT

hi everyone,

Need a little help here.

I'm trying to do on avg of float day in certain range, count number of retailers. here's the expression. but it doesn't work as expected.

count(if({<KYSC.FLOAT_DAY = {"=avg([KYSC.FLOAT_DAY])>=0<1"}>}) distinct KYSC_SALE_CHNL_CD )

please help.

thanks