topic Re: If statement set analysis in Listbox in QlikView

If statement set analysis in Listbox

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

I have this set analysis if statement:

=if(sum({<USE_DESC_TYPE={"Gross Requirements Amt"}>}PERIOD_VAL) >0, 'Yes', 'No')

It works perfectly in a text box. However, It will not work in a listbox, or multibox, or anything which will display it as a selection.

Any ideas?

Thanks.

Re: If statement set analysis in Listbox

tresB — Wed, 08 Aug 2018 10:06:02 GMT

Try adding 'total' like:

=if(sum(TOTAL {<USE_DESC_TYPE={"Gross Requirements Amt"}>}PERIOD_VAL) >0, 'Yes', 'No')

Re: If statement set analysis in Listbox

Chanty4u — Wed, 08 Aug 2018 10:07:09 GMT

may be

=if(aggr(sum({<USE_DESC_TYPE={"Gross Requirements Amt"}>}PERIOD_VAL) >0, 'Yes', 'No'),PERIOD_VAL)

Re: If statement set analysis in Listbox

Anonymous — Wed, 08 Aug 2018 10:10:31 GMT

Only Returned 'Yes' and no 'No' even though there are results which fit under no

Re: If statement set analysis in Listbox

Anonymous — Wed, 08 Aug 2018 10:10:53 GMT

this displayed a blank list box

Re: If statement set analysis in Listbox

pooja_prabhu_n — Wed, 08 Aug 2018 10:14:01 GMT

Hi,

try creating in the script

T1:

Load * Inline [

USE_DESC_TYPE,PERIOD_VAL

Gross Requirements Amt,10000000

B,200000000

C,30000000

D,60700000

E,50000000

]

;

T2:

Join

load USE_DESC_TYPE,

if(USE_DESC_TYPE='Gross Requirements Amt',if(Sum(PERIOD_VAL)>0, 'Yes'), 'No') as listbox

Resident T1

Group By USE_DESC_TYPE;

Re: If statement set analysis in Listbox

tresB — Wed, 08 Aug 2018 10:15:34 GMT

In text also you must be getting either yes or no, but not both, right? With one data set in scope you can't have both outputs possible. There has to be at least one dimension for that. You can then try like:

=Aggr(if(sum( {<USE_DESC_TYPE={"Gross Requirements Amt"}>}PERIOD_VAL) >0, 'Yes', 'No') , <YourDimension>)

Re: If statement set analysis in Listbox

Chanty4u — Wed, 08 Aug 2018 10:22:25 GMT

ok try

=aggr(if(sum({<USE_DESC_TYPE={"Gross Requirements Amt"}>}PERIOD_VAL) >0, 'Yes', 'No'),PERIOD_VAL)

Re: If statement set analysis in Listbox

Anonymous — Wed, 08 Aug 2018 10:35:18 GMT

Perfect, Thank you!