I am making a dashboard in which i want to keep creation of my charts dynamic.
I have data in which I have some Products and each product have some processes. Now different products can have different number of processes.
What i am trying to do is - I want to give a filter for products value and when a user selects a product its corresponding processes should come in charts as dimension and expression for all will be same.
For example : if my product A has 3 processes a,b,c and my product B as 2 processes x,y.
Now when i select A from filter i should get 3 charts with dimension a in chart 1, b in chart 2 and c in chart 3. And expression for all 3 is sum(volume).
If i select B now from filter i should get 2 charts with dimension x in chart 1, y in chart 2. And expression for both charts is sum(volume).
Is it possible to achieve in Qlikview. Or any alternate/closest solution I can have..??