Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
younlim91
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
tresesco
MVP
MVP

@younlim91 

Try with single quotes, like:

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

View solution in original post

6 Replies
MayilVahanan

Hi @younlim91 

Try like this

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

Thanks & Regards,
Mayil Vahanan R
younlim91
Contributor II
Contributor II
Author

It's giving me "Error in Expression" 

tresesco
MVP
MVP

@younlim91 

Try with single quotes, like:

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

View solution in original post

edwin
Specialist III
Specialist III

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

younlim91
Contributor II
Contributor II
Author

I'm creating dimension in a chart

younlim91
Contributor II
Contributor II
Author

It works! thank you so much!