topic Mini Waterfall in Table in QlikView

Mini Waterfall in Table

fheidenstecker — Tue, 18 Feb 2014 13:21:39 GMT

Hi there,

i was trying to create a mini waterfall in a straight table.

Creating a waterfall chart in QlikView is really easy. I used a rangesum / above combination for the offset, works like a charm!

But now i want to mimic the waterfall chart in a straight table, cause i want to have more measures per line.

My idea was to use 2 Segments, using the first one as the offset and then turning it to foll transparency

I tried to copy & paste my offset formula from the chart to the gauge starting value. But no success. I tried to statically set the starting value based on RowNo(), but obviously i can't reference the row number from within this starting measure ?!?

Does anyone have an idea how to resolve this?

I would be greatful for suggestions,

Fabian

Re: Mini Waterfall in Table

rbecher — Tue, 18 Feb 2014 13:59:12 GMT

Hi Fabian,

I think this is not possible because "Lower Bound" will only calculated once per chart, not per line. I tried to set dynamically in the attached example but doesn't work...

- Ralf

Re: Mini Waterfall in Table

fheidenstecker — Tue, 18 Feb 2014 16:05:00 GMT

Thanks for your effort, Ralf.

Do you think it is a Bug or a feature that the boundry is only calculated per chart. I mean, to draw the gauge, calculation has to be done per line, so from my point of view, that is a mixed logic ?

Cheer,

Fabian

Re: Mini Waterfall in Table

rbecher — Tue, 18 Feb 2014 16:09:45 GMT

I think it's a feature. The segment size is static (per chart), the filling/coloring is dynamic (per line).

Re: Re: Mini Waterfall in Table

marcus_sommer — Wed, 19 Feb 2014 09:36:20 GMT

Perhaps the repeat() function could be an alternative - it depends from the font-type and the adjustment from repeat-counter is tricky, but this approach could work.

- Marcus

Re: Re: Mini Waterfall in Table

rbecher — Wed, 19 Feb 2014 09:39:20 GMT

Hey, this is a nice and interesting old schoolish ASCII art. Never thought of it.. 😉