topic Re: sum if count distinct in QlikView

sum if count distinct

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have problem with counting:

firstly i tried

sum(if(count(distinct(id_branz))<=5,RoznicaWartNettoZakupu,0))

Shows error in expression so i tried with this:

Sum(IF(Aggr(Count(DISTINCT [id_branz]),[SklepId])<=5,RoznicaWartNettoZakupu,0)) but shows nothing

It's stocktaking. all i wanted to show its stocktaking in which included only few NazwaBranzy, not all

settu_periasamy — Wed, 11 May 2016 15:29:54 GMT

Try to split the expression and check it.. then you may know which part is not working. .

avinashelite — Wed, 11 May 2016 16:33:08 GMT

try like this

if(count(distinct id_branz)<=5,sum(RoznicaWartNettoZakupu),0)

sunny_talwar — Wed, 11 May 2016 17:13:25 GMT

How about this?

Sum(Aggr(If(Count(DISTINCT [id_branz]) <= 5, RoznicaWartNettoZakupu, 0), [SklepId]))