Compare Dimension values using Variable expression

[vidyasagar159]

Hi All,

I have a simple requirement. But facing challenges to achieve it.

Question: From the below table compare Fruits sales by Year.

TableA: 

Fruits	Year	Sales
Grapes	2021	-38
Grapes	2022	10
Apples	2020	20
Apples	2021	30
Apples	2022	50

TableB:

Fruits	Year	Sales	Comparing Grapes
Apples	2020	20
Apples	2021	30	-38
Apples	2022	50	10

below are expressions tried in Set Analysis for Comparing Grapes, but nothing works, maybe it's because Frutis is a default single select filter. Grapes value in set analysis has to be Varaible. 

1. = Sum(total {$<Frutis={'Grapes'}>} Sales)
2. = aggr(Sum(total {$<Frutis={'Grapes'}>} Sales),Fruits,Year)

I want to use this expression under the combination chart, where the User can choose his Fruit from the Default filter and if want to compare this with other Fruit then uses Input Variable.

I am new to Qlik, Help would be appreciated.  

[vidyasagar159 · Accepted solution]

I have tried Alternate State. Looks like it's working. I have created the following expression

Sum({"Alternative State"} Sales).