Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a requirement to show the share of a product in its market (There are multiple markets).
Attached is a excel sheet showing what I want to achieve and qvw with calculation I'm using.
This works only when a product is selected.
Please help me with this.
Go to Solution.
I have updated the previous file.
Check on this file. This is based on your excel attached file.
Thanks Janzen for a speedy reply.
But this works only when Product is not selected.
Here is your solution.
Is there a way to make this independent of month selection.
I tried adding Month=, in the set expression. But does not seem to affect it.
What do you mean by independent of month selection? Does my solution fix your problem? If it does, kindly mark as correct for future references.
What I mean is, even if I select a month, it should show me values for all 3 months in the chart.
Is this possible?
Thanks in advance.
Found the solution on this thread: