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

jblomqvist — Thu, 18 May 2017 13:22:51 GMT

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?

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

Digvijay_Singh — Tue, 23 May 2017 05:22:18 GMT

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 -

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

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

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