topic Create Waterfall dynamically, depending on field selections in QlikView

Create Waterfall dynamically, depending on field selections

Tue, 27 Mar 2012 12:08:54 GMT

Hello!

Can anyone please give an advice on how to do the following...

I have loaded a database table like follows:

Factory	Part	Cost	Selected in fieldlist
A	X	10	Yes (Part fieldlist)
B	X	11	Yes (Part fieldlist)
A	Y	9	Yes (Part fieldlist)
B	Y	13	Yes (Part fieldlist)
A	Z	7	Yes (Part fieldlist)
B	Z	6	Yes (Part fieldlist)
A	U	4	No
B	U	7	No

How can I make a waterfall out of this table? I want to show the total costs for each Factory at the left and right, and the differences in the middle?

Dimension values needed: 'Factory A','Part X','Part Y','Part Z','Factory B'

Values for the dimension: Sum(<$Factory={'a'}> Cost), 1 (green),4 (green),-1 (red), Total cost factory B.

If I choose to select part U as well, I would need the waterfall to include this value as well... Is this possible?

The dimension part is the most challenging, as I am aware that I can use set analysis to get the correct dimensions. Also I am aware of the offset-technique for creating the waterfall.

Create Waterfall dynamically, depending on field selections

Tue, 27 Mar 2012 16:49:15 GMT

not exactly an answer to your question but can you have not one but three charts side to side: Sum(A), Part Costs, Sum(B)?

Re: Create Waterfall dynamically, depending on field selections

Tue, 27 Mar 2012 19:28:45 GMT

Hello and thanks for the response

I will try and illustrate what I need. See the attached file. This was based on another example found on the site, but it is not dynamic... And I have to construct the data in a table during load.

Is it possible to allow for a dynamic version of this (where the factories total costs are calculated (based on selection of costs to include) and displayed in each end, and the costs displayed as a waterfall, bridging between the two factories?

Best regards