Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

If statement

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)

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: If statement

Oh okay... try this

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

View solution in original post

4 Replies
Highlighted

Re: If statement

May be you need or between the two conditions?

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

Highlighted
Contributor III
Contributor III

Re: If statement

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.

Highlighted

Re: If statement

Oh okay... try this

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: If statement

That worked. Thank you!