Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
beunderf
Partner
Partner

Block chart question

Dear all,

I have the following example data:

Year Type Product Amount
2014ForecastA245
2014ForecastB100
2014RealizedA100
2014RealizedB80
2014UnforeseenA10
2014UnforeseenB10

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!

Cheers,

Frank

1 Solution

Accepted Solutions
ecolomer
Master II
Master II

4 Replies
ecolomer
Master II
Master II

Is that you need?

beunderf
Partner
Partner

Hi Enrique,

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. 🙂

Frank

ecolomer
Master II
Master II

beunderf
Partner
Partner

That's it!! Thanks!!