topic Re: add a calculated column in QlikView

add a calculated column

Tue, 08 Jul 2014 13:09:10 GMT

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

tresB — Tue, 08 Jul 2014 13:13:55 GMT

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

alexandros17 — Tue, 08 Jul 2014 13:14:21 GMT

LOAD

NAME,

POINT,

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

...

Let me know

mdmukramali — Tue, 08 Jul 2014 13:21:38 GMT

Dear,

kindly find the attached file..

i hope it will help you.

thanks,

Mukram