topic Re: How to use QlikSense if statement in QlikView

How to use QlikSense if statement

qwebnm — Tue, 06 Dec 2022 03:48:42 GMT

I want to make a statement so that if the value of column 1 is 1 to 3, column 2 will return 2, and if the value of column 1 is 7, then column 2 will return 1.

What should I do?
I'm not good at nesting QlikSense if statements.

please help me.

Thanks you!

Re: How to use QlikSense if statement

Saurabh_K14999 — Tue, 06 Dec 2022 08:50:01 GMT

Hi,

Try the below expression:

If(Value=7,'1',If(Value>=1 and Value<=3,'2','NA'))

Replace 'Value, with your column 1 name.

Regards,

Re: How to use QlikSense if statement

hic — Tue, 06 Dec 2022 08:51:51 GMT

Column1,
If(1<=Column1 and Column1<=3, 2,
If(Column1=7, 1,
'other value')) as Column2,
Column3,
...

Re: How to use QlikSense if statement

MayilVahanan — Tue, 06 Dec 2022 09:00:31 GMT

Try like below

Load *,

If(Match(Column1, 1,2,3), 2,
If(Column1=7, 1,
'other value')) as Column2
from ursource;