topic Re: If statement in QlikView

If statement

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

Hello,

My if statement is returning 0 in the size field for the '40 <44' amount instead of '40 < 44'. What am I doing wrong?

=if(Size='40 <44', Size='40 < 44',Size)

Re: If statement

sunny_talwar — Mon, 04 Jun 2018 19:22:00 GMT

May be you need or between the two conditions?

=if(Size='40 <44' or Size='40 < 44', Size)

Re: If statement

Anonymous — Mon, 04 Jun 2018 19:26:35 GMT

It's only one condition. I've got some Excel sheets with 40 <44 and others with 40 < 44. So if Size is equal to '40 <44', then I want it to equal '40 < 44', otherwise keep Size.

Re: If statement

sunny_talwar — Mon, 04 Jun 2018 19:36:19 GMT

Oh okay... try this

=if(Size = '40 <44', '40 < 44', Size)

Re: If statement

Anonymous — Mon, 04 Jun 2018 19:39:30 GMT

That worked. Thank you!