Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
I have tried Alternate State. Looks like it's working. I have created the following expression
Sum({"Alternative State"} Sales).
I have tried Alternate State. Looks like it's working. I have created the following expression
Sum({"Alternative State"} Sales).