QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

alternate state - one table two alternate state compare two years/months

Hi All,

I am trying to create straight table, where my dimension is Product Number, next I need to setup 3 expression

1. Sum of Sales for chosen  Year and Month State_1

2. Sum of Sales for chosen  Year and Month State_2

3. Difference between two above

I have two sets of Year and Month list box, one for each alternate state

In my working sheet(which is under alternate state = State_1)  i created stright able under State_1

As dimension I have chosen Product_Number my expression look as below:

1) =SUM({State_1<Month = {'\$(=GetFieldSelections(Month))'}>}SoldPacks)

2)  =SUM({State_2<Month = {'(=GetFieldSelections(Month))'}} >}SoldPacks)

3) Expr1-Expr2

The purpose of that is to allowed user to compare any month of the chosen year vs. any month of another chosen year

I.e. Mar 2018 vs Jun 2017

First expression is working, but I believe it is because has the same alternate state as whole sheet and object (straight table),  second one return only 0

I also tried to modify expression by adding year, the same result

=SUM({State_2<Month = {'(=GetFieldSelections(Month))',Year = {'(=GetFieldSelections(Year))'}} >}SoldPacks)

BR

Michal

1 Solution

Accepted Solutions
Highlighted
MVP

Re: alternate state - one table two alternate state compare two years/months

It almost seems like you just need this

State 1 expression

``=Sum({State_1} SoldPacks)``

State 2 expression

``=Sum({State_2} SoldPacks)``

2 Replies
Highlighted
MVP

Re: alternate state - one table two alternate state compare two years/months

It almost seems like you just need this

State 1 expression

``=Sum({State_1} SoldPacks)``

State 2 expression

``=Sum({State_2} SoldPacks)``

New Contributor II

Re: alternate state - one table two alternate state compare two years/months

Yes, exactly I  just need this. Thank you!