Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

add a calculated column

I need to add a calculated column, the table original is like bellow

NAMEPOINT
AAA1
BBB2
CCC3
DDD4
EEE5
FFF6
GGG7

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???

NAMEPOINTLEVEL
AAA1LOW
BBB2LOW
CCC3LOW
DDD4MEDIUM
EEE5MEDIUM
FFF6HIGH
GGG7HIGH
3 Replies
Highlighted
MVP
MVP

Re: add a calculated column

If(POINT<4, 'LOW', If(POINT<6, 'MEDIUM' , 'HIGH')) as LEVEL

Highlighted

Re: add a calculated column

LOAD

     NAME,

     POINT,

     If(POINT>=1 and  POINT<=3, 'LOW', If(POINT>=4 and  POINT<=5, 'MEDIUM', 'HIGH')) as LEVEL

...

Let me know

Highlighted
Specialist III
Specialist III

Re: add a calculated column

Dear,

kindly find the attached file..

i hope it will help you.

thanks,

Mukram