Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

If statement with Min function

Hello,

I'm trying to create a dimension like "if ((min(A,B)-C) > D, "N", "Y")". Please help! Thanks!!

younlim91_0-1605146302943.png

 

1 Solution

Accepted Solutions
MVP
MVP

@younlim91 

Try with single quotes, like:

=if(RangeMin(A,B)-C > D, 'N', 'Y')

View solution in original post

6 Replies

Hi @younlim91 

Try like this

=if(RangeMin(A,B)-C > D, "N", "Y")

Thanks & Regards,
Mayil Vahanan R
Contributor II
Contributor II

It's giving me "Error in Expression" 

MVP
MVP

@younlim91 

Try with single quotes, like:

=if(RangeMin(A,B)-C > D, 'N', 'Y')

View solution in original post

Specialist II
Specialist II

are you creating the dimension in a chart or in the data model?

Contributor II
Contributor II

I'm creating dimension in a chart

Contributor II
Contributor II

It works! thank you so much!