Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a Combo Chart with two Dimensions.
2. Product Group
In the Chart I want to show:
1. Expression: per Year the sum of Amount per Product Group in stacked bar (sum(amount)
2. Expression: first Expression * 115% in Lines (sum(amount) * 1,15)
3. Expression: a fixed target value in Lines (This can possibly solved with a reference line in presentation)
QlikView makes automatically o grouped bar if I have a second expression.
There are over 100 product groups available, so I can't do it with set analysis for every product group.
thanks for your tips
How is looking now?
like this: This is only an Example with only 3 Product Groups.
Anil, any idea?
I may have idea or at least work around will work. But, Really mockup needed