topic Problem with cummulation in line chart in QlikView

Problem with cummulation in line chart

jozisvk11 — Wed, 15 Mar 2017 09:47:48 GMT

Hello friends, I have problem with cummulation in graph.

Dimension is:

if([Finacial month] <= month(today()), [Finacial month] , null())

Expresion is:

Rangesum(above(Sum ({<[ID account] = , [Division] = {"VSC", "Zlievareň"} , $(vSetMaxFinancialYear) >}[Plan of Revenues]) -

Sum ({<[Financial transaction] = {"U99"}, [ID account] = , [Division] = {"VSC", "Zlievareň"} , $(vSetMaxFinancialYear) >}[Plan of Revenues]),0, RowNo())) . Graph is shown also cumulative values, but I don´t want this.

I need only this:

How can I do that ???

Thank you

Re: Problem with cummulation in line chart

PrashantSangle — Wed, 15 Mar 2017 09:51:43 GMT

Hi,

tick supress null in dimension tab.

Regards,

Re: Problem with cummulation in line chart

jozisvk11 — Wed, 15 Mar 2017 09:55:20 GMT

It works, thank you

Re: Problem with cummulation in line chart

Frank_Hartmann — Wed, 15 Mar 2017 10:06:50 GMT

If you mark the post as helpful the thread is not closed,

so please close this thread by marking the correct answer as the correct one which will be useful for others looking into this thread.

Re: Problem with cummulation in line chart

jozisvk11 — Wed, 15 Mar 2017 10:22:54 GMT