topic Re: List Box Expression in QlikView

List Box Expression

dseelam — Wed, 09 May 2018 18:08:22 GMT

How to write below if condition as an expression in the list box ? which is working fine in straight table.

if(Item.STATUS='P',Item.STATUS,

IF(sum(DMND)>0,if(sum(ONHAND-DMND)<0,'A','S'),'P'))

Need some thing like this

Re: List Box Expression

vishsaggi — Wed, 09 May 2018 18:33:44 GMT

Try:

= Aggr(if(Item.STATUS='P',Item.STATUS,

IF(sum(DMND)>0,

if(sum(ONHAND-DMND)<0,'A','S'),'P')), Item.STATUS)

Re: List Box Expression

dseelam — Wed, 09 May 2018 18:55:26 GMT

Vishwa,

It created a list box but it's giving wrong results when I filter according to logic it should select only A

Re: List Box Expression

vishsaggi — Wed, 09 May 2018 18:56:39 GMT

Can you share this sample to look into? can you also give a reason why only A should be coming?

Re: List Box Expression

dseelam — Wed, 09 May 2018 19:03:03 GMT

created this field in straight table depending on active, slow and purge items as status using expression

if(Item.STATUS='P',Item.STATUS,

IF(sum(DMND)>0,if(sum(ONHAND-DMND)<0,'A','S'),'P'))

which is working accurate according to numbers tested trying to get same status column as list box so that can use it as a filter

Re: List Box Expression

vishsaggi — Wed, 09 May 2018 19:07:45 GMT

What are the dimensions you used in your straight table? Just use those dimensions and add in your aggr() field in your list box expression and see? If not, share some sample data to look into.