Discussion Board for collaboration related to QlikView App Development.
I have the following example data:
Forecast adds up to: 345
Realized adds up to: 180
Unforeseen adds up to: 20
Now I want to create a Block chart with 'Type' as dimension, but the expression should do the following calculation:
Forecast = sum(Forecast) - sum(Realized) = 165
Realized= sum(Realized) = 180
Unforeseen = sum(Unforeseen) = 20
What kind of set analysis or other solution could I use.
See attached example!
View solution in original post
Is that you need?
Thank for you answer. In your example the variables show the right values, but the block chart does not. It shows 330 for 'Forecast', instead of the desired 165. 🙂
That's it!! Thanks!!