Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use nested if in expression

Greetings All,

Can aynone please suggest how to write this script in the expression :

IF(Expressions = 'Compliant' ,IF(mod(X, Y) = 0, 'Yes'),' ')

Here Expression is a field.

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Try this:

If(Expression = 'Compliant' and Mod(X,Y)=0,'Yes','')

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

Try this:

If(Expression = 'Compliant' and Mod(X,Y)=0,'Yes','')

Not applicable
Author

Many Thnx!