topic Re: waterfall chart with dimension in QlikView

waterfall chart with dimension

markticoy — Mon, 27 Jul 2015 05:55:45 GMT

Hi All,

I have a QlikView requirement of waterfall chart.

The chart should display the top 10 contributors of revenue from last year vs current year. how should I build my bar chart to do this ?

As of now, my waterfall is like this:

The green bars should display the top 10, let's say, brands. how can i achieve this kind of output ? what should be my expression ? As of now revenue per brands are scripted (no dimension). how can i identify the top 10 brands ?

Thanks !

Re: waterfall chart with dimension

Kushal_Chawda — Mon, 27 Jul 2015 06:02:25 GMT

Please upload qvw file

Re: waterfall chart with dimension

qlikviewwizard — Mon, 27 Jul 2015 06:09:16 GMT

Hi MarkTicoy

Please upload sample file with the data. It will help folks to provide solution quickly.

Re: waterfall chart with dimension

markticoy — Mon, 27 Jul 2015 06:26:52 GMT

The qvw file is too big to upload (185 MB).

Re: waterfall chart with dimension

qlikviewwizard — Mon, 27 Jul 2015 06:48:27 GMT

Hi MarkTicoy

Use Debug load and limit the no of records to 1000 or to other value. Then size will be reduced. Thank You.

Re: waterfall chart with dimension

jonathandienst — Mon, 27 Jul 2015 07:02:42 GMT

This does not look like a waterfall chart as I know them. Normally the waterfall elements are the broken-down components of the movement between the starting value (LY in your case) and the ending value (CY), so the first component starts at the LY value, and last movement component ends at the CY value.

Are you sure that this is the best way to display your data?