topic Create expression when expression 1 is higher than expression 2 in QlikView

Create expression when expression 1 is higher than expression 2

loke2014 — Sat, 13 Feb 2016 08:31:18 GMT

Hi,

I have created a straight table with 2 total sales expressions as below:

(a) Current month with dimension =Product 1, Product 2, Product 3, Product 4

(b) Previous month with dimension =Product 1, Product 2, Product 3, Product 4

I would like to create a third expression whereby it is populated with the difference between current month and previous month total sales by product as dimension in a new column.

Any idea how this can be done?

Thanks.

Re: Create expression when expression 1 is higher than expression 2

swuehl — Sat, 13 Feb 2016 16:27:13 GMT

Product is your dimension?

Then just use something like

=Column(1) -Column(2)

or rewriting your original expressions, e.g.

=Sum(Sales) - Sum( {<PrevMonthSetAnalysis>} Sales)

Re: Create expression when expression 1 is higher than expression 2

loke2014 — Sat, 13 Feb 2016 16:30:32 GMT

Thank you for the guidance.