topic Re: Count on sum in QlikView

Count on sum

Anonymous — Mon, 15 Jan 2018 20:21:07 GMT

Hello,

i need your help to calculate a value.

So,this is my dataset

I want to the take, for every "COD PERSON" that have two different "COD ANIMAL" ,the row that have Amount, for each row, <=5000.

So in my table is expected to have

C	7	CAT1	30
C	8	CAT5	50

how can i do?? I need to calculate this in frontend

rubenmarin — Mon, 15 Jan 2018 21:13:36 GMT

Hi Khawar, you can try with:

Sum({<[COD PERSON]={"=Count(Distinct [COD ANIMAL])=2"}, AMOUNT={"<=5000"}>} AMOUNT)

Change "=2" to ">1" for "more than 1 different animal" instead of "two different animals"

uacg0009 — Tue, 16 Jan 2018 06:27:37 GMT

Hi Khawar,

Hope below is what you want.

Thanks.

Aiolos

Anonymous — Tue, 16 Jan 2018 16:43:19 GMT

your qvw is correct!!!

can you explain me, how it work "Aggr(NODISTINCT " ?

thx

uacg0009 — Wed, 17 Jan 2018 02:01:12 GMT

Hi Khawar,

The Aggr function is just like a group by in the front-end.

And add "nodistinct" means for every group, the expression will calculate a value.

I think you can try to create some table and value to try to use it

or you can find some other examples to see.

Hope I have clarified the aggr nodistinct.

Please make my answer to "correct" status, so other person will know the thread is finished.

Thanks.

Aiolos