Discussion Board for collaboration related to QlikView App Development.
i have a straight table in qvw
EO - Expression but this column is not in raw data
Cat(D) Value(E) Amount Charged(E)
0-14 100 50
15-30 100 25
now i need the below information outside the above table but using the values of above table:
Scenerio 1: if(Cat='0-14' and Amount charged>20, Amount charged*20,0)
Scenerio 2: if(Cat='15-30' and toal>20, total*20,0)
is it possible?
Any luck on this one?
You say that you want a fourth column. Then you say that you want to sum column E. Are you able to clearify what you are looking for?
any update on the above query