Discussion Board for collaboration related to QlikView App Development.
Please, it's urgent.
I have taken nested ifs for dividing the column into different columns in straight table.
If(BusinessAmount=1,’0-30’, If(BusinessAmount=2,’31-60’…. ,If(BusinessAmount=7,’Future’)
It has to show 1st table but it is showing 2nd table i.e. without future value it is showing.
please copy/paste in the exact expression you are using. Please also add a screenshot of a list box showing the raw businessamount values ( 1....7) . That should help point us in the right direction
Post your complete nested if statement.