topic Re: Count Set Analysis Help in QlikView

Count Set Analysis Help

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

I am attempting to count a check within a certain range. One check addresses multiple items so I need to total the amount and count the check as '1' I keep getting an error, i know it is a set analysis can you see where my issue is in the statement below.

=count(DISTINCT(If([CHK_NO] >= Sum(TOTAL {<[PAID_AMT] ={">0<2500"}>}[PAID_AMT]))))

Also tried...

=count(DISTINCT(If([CHK_NO] >= 0 and sum([PAID_AMT]) <= 2500, sum([PAID_AMT]))))

Any assistance is greatly appreciatted

Re: Count Set Analysis Help

sunny_talwar — Fri, 22 Jun 2018 17:40:58 GMT

Not sure what you are trying to do... would you be able to share some data and the output you expect to see from it?

Re: Count Set Analysis Help

Anonymous — Fri, 22 Jun 2018 17:50:18 GMT

Here is the output I am using you will see i get counts, but the numbers are wa off, it seems to be counting the amounts and not the checks. Note in the second screen shot i selected 1 check and it counts it 5 - 6 times.

Re: Count Set Analysis Help

Anonymous — Mon, 25 Jun 2018 10:44:33 GMT

Hi,

What are you trying to count. Seems like you are not counting anything

Re: Count Set Analysis Help

Anonymous — Mon, 25 Jun 2018 16:27:36 GMT

Hello Thabang;

I am attempting to count the number of individual checks in a specific amount range. I have 4 defined ranges and I am not sure if i am doing the SA correct. Per the image below, note i have one check selected so it should just be the SUM of that 1 check, but it lists the amounts individually as if they were separate checks.

Re: Count Set Analysis Help

Anonymous — Tue, 26 Jun 2018 08:44:33 GMT

Hi Richard,

Perhaps move the check into the backend script and treat as a kind of flag.

Then in your set analysis, use the flag