topic Re: Re: Block chart question in QlikView

Block chart question

beunderf — Mon, 24 Nov 2014 20:48:51 GMT

Dear all,

I have the following example data:

Year	Type	Product	Amount
2014	Forecast	A	245
2014	Forecast	B	100
2014	Realized	A	100
2014	Realized	B	80
2014	Unforeseen	A	10
2014	Unforeseen	B	10

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

Re: Block chart question

ecolomer — Mon, 24 Nov 2014 21:31:44 GMT

Is that you need?

Re: Block chart question

beunderf — Mon, 24 Nov 2014 21:39:57 GMT

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

Re: Re: Block chart question

ecolomer — Mon, 24 Nov 2014 21:42:34 GMT

And now?

Re: Re: Block chart question

beunderf — Mon, 24 Nov 2014 22:15:52 GMT

That's it!! Thanks!!