Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

Full accumulation with month dimension: line extends even though I have no data

Hello community!

I am creating an accumulated graph, showing only the current year, with actual figures (green), budget (pink) and last year's actuals (blue). I have one dimension (month) and three expressions with full accumulation, in which I use set analysis to "lock" year to the current.

As you see in the image, the green line continues over the whole year even though I only have data for january. I want the green line to be discontinued at the latest month for which I have data for actual figures (meaning that I, for example, only want a green dot right now in January). I have tried "suppressing zero values" and similiar options. Anyone know how I can accomplish this?

Full accumulation.jpg

Thanks in advance!

Kind regards

Henrik

5 Replies
Highlighted
Not applicable

Re: Full accumulation with month dimension: line extends even though I have no data

Highlighted

Re: Full accumulation with month dimension: line extends even though I have no data

The problem is due to accumulation, so the first value is considered in all others month ... try not to accumulate and verify it works ...

If so, try to "compute" accumulation in the expression

Highlighted
er_mohit
Honored Contributor II

Re: Full accumulation with month dimension: line extends even though I have no data

i think for last expression in axes tab here tick on left bottom make it right top

hope it helps

Highlighted
Not applicable

Re: Full accumulation with month dimension: line extends even though I have no data

Thanks for quick answers!

Alessandro Saccone: I have tried using this as an expression with "no accumulation chosen":

rangesum(above(Sum( {$<Some set analysis>}, Sales), 0, Rowno()))

But I still get the same result as above.

Mohit Sahrma: The result is not what I want, the line still extends throughout the whole year.

If I disable both the "Budget" and "Previous year" expressions and check "Suppress Zero-Values" on the presentation tab, I get the desired results.

I also get the desired results when I use two dimensions (month and year) with one expressions in another graph:

Full accumulation 2.jpg

Highlighted
Not applicable

Re: Full accumulation with month dimension: line extends even though I have no data

Thanks Mario, an interesting read. I tried to hide the line after the current month by making it thinner and changing color to the background color, but the result was not great. Especially when I made selections in the date dimension.

I'm still looking for a more stable and permanent solution.