topic Re: Help with set analysis in QlikView

Help with set analysis

Sun, 24 May 2015 08:20:48 GMT

Hi,

I am trying to do something like the following:

COUNT(DISTINCT{$< (amount-pay-prep)={">0"}>} P_ID)

how can i handle with the condition (amount-pay-prep), it shows error and i need to compare the result of these values. I tried to use RANGESUM, ,dont know if it is in the proper pplace or not but also it does not work.

appreciate any help.

Thanks

Re: Help with set analysis

PrashantSangle — Tue, 26 May 2015 05:51:20 GMT

Hi,

Try like

COUNT({<amount-pay-prep={">0"}>}Distinct P_ID)

or Count(if(amount-pay-prep>0,Distinct P_ID))

Regards

Re: Help with set analysis

prajapatiamar38 — Tue, 26 May 2015 07:41:20 GMT

Hi,

Try this

=COUNT({< (amount-pay-prep)={">0"} >}DISTINCT P_ID)

Thanks

Re: Help with set analysis

Kushal_Chawda — Tue, 26 May 2015 07:47:20 GMT

try like this

count(DISTINCT {<[amount-pay-prep]={">0"}>}P_ID)