Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Display of cumulative results based on a selection

Hi all,

I'm a bit stuck with one of my apps:

I've got 2 graphs, one with the sales per week, and beside one with the cumulative results of the first one.

Easy and correct for the whole periode, but to ease the reading of the graph, I'd like to display the final 30 weeks (30 is an example).

So it works properly for the week / week graph, but the cumulative one is only calculating the cumulative results for the last 30 weeks, without taking into account the data of the weeks before the selection.

So I'd like just to make a kind of zoom to read more easily the graph, with keeping the results of the cumulative option based on the whole period.

Does anyone has an idea?

Thanks for your help.

Jérôme.

4 Replies

Re: Display of cumulative results based on a selection

See this document.


talk is cheap, supply exceeds demand
Not applicable

Re: Display of cumulative results based on a selection

Thanks a lot, I'll look through it but it seems to answer to my request!

I'll let you know.

Regards.

Jérôme.

Not applicable

Re: Display of cumulative results based on a selection

My main issue, is with that tip, I'm adding a dimension, and as I need to do a graph after the calculation I'm a bit stuck for the moment...

I'm still chasing for the right method, and I will share.

Not applicable

Re: Display of cumulative results based on a selection

Hi Jerome,

did you find a kind of solution ?

I'm wondering if it is possible to zoom in a line chart for istance a part of it manteining as starting point of zoomed new chart the cumulated value present on original chart. I mean without loosing it and starting as usual from 0 first value.

Community Browser