topic Re: Waterfall Diagramm with Dimensions in QlikView

Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 15:39:56 GMT

Hi all

Maybe somebody had already the same issue (I'm sure :-))

I want to create a Waterfall Diagramm. Starting on the left with total Budget and ending on the right with total Actuals. Between there should be the difference by customer or by product category.

How can I avoid that Totals for Actual and Budget get split by the dimensions?

Thanks for your help

Oliver

Re: Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 15:45:31 GMT

little bit clear what are the dimensions u have and what u want final output

Re: Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 16:15:27 GMT

Hi all

What I need is a split by dimensions (for example Customer or products) only of the "Vario"-Data.

The issue is that for Actual and Budget there is also this split by Dimension available. As it does'nt make sense to show the gap between budget and actuals for every dimension I want to show the total of Sales and Budget, but for Vario the split by dimension. There must be a formula or something that dimensions are only visible for "Vario"...

hope this helps...

This happens when I just enter a Dimension (product) ==> doesn't make sense....

Re: Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 16:18:26 GMT

try like this

aggr(sum(amount),product))

instead of amount put what u need

Re: Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 16:26:31 GMT

Still same issue.. I have budget split by product category...

Re: Waterfall Diagramm with Dimensions

Mon, 10 Nov 2014 16:27:40 GMT

Hi ,

thanks for making correct answer and what expression u tried ? what i given same or did u make any changes? put it here it will be useful for others in future

Re: Waterfall Diagramm with Dimensions

mark_casselman — Thu, 13 Nov 2014 00:01:24 GMT

Hi Oliver,

Tried several solutions, the only one that worked was through a script.

See attached file...

Mark

Re: Waterfall Diagramm with Dimensions

Thu, 13 Nov 2014 01:07:45 GMT

HI,

I Have seen above application, it was fantastic ,

but how u blocked the sheetproperties and document properties option can u explain in clear.

Re: Waterfall Diagramm with Dimensions

mark_casselman — Thu, 13 Nov 2014 20:10:40 GMT

What do you mean with 'blocked properties'. I'm afraid I don't understand your question.

You can see the script by 'file - edit script' or CTRL+E.

You can see the chart properies by right clicking on the chart. Under expression, tou will find 'sum(value)' as expression and if you click on the plus sign left of the expression, you can also see the 'bar offset' expression 'RangeSum(above(sum(value),1,100))'.

Is that you question ?

Mark