Discussion Board for collaboration related to QlikView App Development.
I need to add a calculated column, the table original is like bellow
i want to add a columne LEVEL, is value of point between 1 to 3, it's LOW, between 4 to 5, it's MEDIUM,else, HIGH
The final table is like this ? How to proceed???
If(POINT<4, 'LOW', If(POINT<6, 'MEDIUM' , 'HIGH')) as LEVEL
If(POINT>=1 and POINT<=3, 'LOW', If(POINT>=4 and POINT<=5, 'MEDIUM', 'HIGH')) as LEVEL
Let me know
kindly find the attached file..
i hope it will help you.