Discussion Board for collaboration related to Creating Analytics for QlikView.
I have the follow information:
Month Category Product Value
Feb 1 Emission $917
Feb 1 Cancellation -$25
Feb 2 Emission $892
Feb 2 Cancellation -$873
So, for business reasons, users need view in a sheet the information filtering Category 1 but in the pivot table Category 1 and Category 2 with Cancellation:
Month Product Value
Feb Emission $917
Feb Cancellation -$25
Feb 2 - Emission -$873
*Note that sheet has an action filtering Category = 1 when user enable sheet.
I hope be clear with explanation.
Go to Solution.
See attached example.
It was so easy... Do you have documentation about work with that expression?
- Javier Florián
I have an additional issue,... the requirement was modified:
Sheet filter applies when Category = 1, my graph shows values by Product Group, but I need add to chart values when Product = Throwback
Is possible with set expression?
Thanks in advanced.
If you always want to show Cancellation and Throwback then modify the expression to:
Great, regards Wassenaar!