topic IF in QlikView

IF

Pujitha — Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

=If(VLAGreaterThan=1,'<30days',If(VLAGreaterThan=3,'>30days',If(VLAGreaterThan=6,'>60days'))) is there any way can we write this expression without if and when I giving this in Calculated expression for "PIVOT TABLE" . Can we write this expression without "IF" please help me out.

Re: IF

sergio0592 — Thu, 01 Nov 2018 20:01:03 GMT

Hi,

Try with =

pick(match(VLAGreaterThan,'1','3','6'),'<30days','>30 days','>60 days')

Re: IF

juraj_misina — Thu, 01 Nov 2018 21:49:47 GMT

Why don't you create a new field in script with '<30days','>30 days','>60 days' values and then use that field in the pivot table as a dimension?

Re: IF

MarcoWedel — Thu, 01 Nov 2018 22:16:03 GMT

one possible variation:

Pick(Match(VLAGreaterThan,1,3,6),'<30','>30','>60')&'days'

or to keep the sorting order of any other strings:

Dual(Pick(Match(VLAGreaterThan,1,3,6),'<30','>30','>60')&'days',VLAGreaterThan)

hope this helps

regards

Marco