topic Add expression into list box in QlikView

Add expression into list box

samantha92 — Thu, 31 Aug 2017 09:21:03 GMT

Hi everyone,

I have created an expression in a straight table and i would like to add this into a list box so that users are able to filter via the list box.

I have tried numerous ways to add this expression but i know that it wont accept TOTAL.

Is the only way to achieve this by doing a GROUP BY in my script? Will this not affect all of my query?

Here is my expression:

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >'250.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='500.00','2) £250 - £500',

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >='0.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='250.00','1) < £250'))

Any help is much appreciated

Thanks

tresB — Thu, 31 Aug 2017 10:11:15 GMT

Try like:

Aggr(

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >'250.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='500.00','2) £250 - £500',

if(sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) >='0.00' and

sum(TOTAL <[SWIFT ID]>RV_WEEKLY_COST) <='250.00','1) < £250'))

, dim1, dim2..)

dim1, dim2.. would be your chart dimensions that the aggregation is carried out against.

sunny_talwar — Thu, 31 Aug 2017 12:26:37 GMT

If what tresesco‌ gave doesn't work, would you be able to share a sample?

samantha92 — Thu, 31 Aug 2017 12:29:26 GMT

Yes it works!

Thank you so much for your help