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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

How to insert multiple selections in an IF statement for a SUM expression?

Hi there,

I am trying to do something like this:

Field:

Category: Product 1, Product 2, Product 3, Product 4, Product 5

Year: 2012, 2013, 2014

What I want to do is this:

If a user selects Product 1 and Year = 2012, then Sum 1 expression

If a user selects Product 2 and Year = 2012 then Sum 2 expression

If a user selects Product 1, Product 2, and Product 3 and Year = 2012 then Sum 1 expression.

Does anyone know how to write an If statement or a check like this?

1 Reply
Digvijay_Singh

You can put these conditions as  expression's conditon box after clicking on Conditional check box  in expression tab of a straight table. Check this sample -

Capture.PNG