Discussion Board for collaboration related to QlikView App Development.
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
, dim1, dim2..)
dim1, dim2.. would be your chart dimensions that the aggregation is carried out against.
View solution in original post
If what tresesco gave doesn't work, would you be able to share a sample?
Yes it works!
Thank you so much for your help