Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Conditional Expressions with multiple conditions

Is it possible to show an Expression up on two conditions:

In a table I have a condition on an exspression saying "=mSalesAmount" where mSalesAmount is a variable. Hence, the expression is shown only when the variable equals 1. I would like to attached another condition to the expression (e.g. "=mSalesQty").

Is it possible to make a kind of "and" statement in the conditions? (e.g. "=and(mSalesAmount, mSalesQty)")

1 Solution

Accepted Solutions
Highlighted
Not applicable

mSalesAmount = 1 and mSalesQty = 1 ?

View solution in original post

4 Replies
Highlighted
Not applicable

mSalesAmount = 1 and mSalesQty = 1 ?

View solution in original post

Highlighted
Not applicable

Ok - that was easy 🙂

Highlighted
Master III
Master III

Hi Ihan,

So you want the expression as to be

=if(mSalesAmount =1 and mSalesQty =1,1,0)

This can be a way to get this .

Highlighted
Not applicable

Hi Son of Sardar,

As Fantasamagoria suggested I can actually do it without the if()..