topic Re: Pivottable to diagram (rangesum) in QlikView

Pivottable to diagram (rangesum)

Fri, 22 Jul 2016 10:19:51 GMT

Hello,

I have two problems with the visualization of a forecast - diagram.

The first one:

In the pivottable everything is correctly. Here I'm using following formel:

Rangesum(Before($(vAVG)/10 ,0,ColumnNo())))

In the diagram I'm using this formel and it shows me only the exist months:

if( Month<month(Today()), sum( $(vStd)),

Rangesum(Before($(vAVG) ,0,ColumnNo()))

)

The second problem, if I set the filter on Technology, for example "BI", then I get no values for the future month in diagram and also pivottable.

Can you please help me.

Re: Pivottable to diagram (rangesum)

sunny_talwar — Fri, 22 Jul 2016 11:05:39 GMT

How is vStd defined here? Would you be able to share a sample?

Re: Pivottable to diagram (rangesum)

Fri, 22 Jul 2016 11:48:34 GMT

Hi Sunny, vStd is defined: Std/($(vShowHour)) and $(vShowHour) as number

Re: Pivottable to diagram (rangesum)

sunny_talwar — Fri, 22 Jul 2016 12:04:10 GMT

Just out of curiosity, what do you get when you use this:

Sum($(vStd))

Re: Pivottable to diagram (rangesum)

Fri, 22 Jul 2016 12:17:54 GMT

If I do it in the formel of diagram, this diagram doesn't change anything. See the screenshot.

If I give this formel Sum($(vStd))in the textbox, then I get the whole amount -> correct.

Re: Pivottable to diagram (rangesum)

sunny_talwar — Fri, 22 Jul 2016 14:08:43 GMT

Would you be able to share a sample to look at?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Pivottable to diagram (rangesum)

Wed, 03 Aug 2016 08:59:31 GMT

Hi Sunny,

sorry for my delayed reply. I attached the QV sample. Please look on this.

How I have to handle formel in diagram ?

and why if I select an application, then I get no values shown for the FC month in diagram and also in the table?

Re: Pivottable to diagram (rangesum)

sunny_talwar — Wed, 03 Aug 2016 12:22:55 GMT

Try this expression out:

If(Month < Month(Today()),

Sum($(vStd)),

Rangesum(Above($(vAVG) , 0, RowNo())) + Avg({1}0)

)

Re: Pivottable to diagram (rangesum)

Wed, 03 Aug 2016 13:12:47 GMT

many Thanks! It works! Can you please explain me this : Avg({1}0) If I want to have total sum of the month, I can use also this formel. I need only click in the diagram on the "accumulation" Jan = 172 Feb = 172 +178 Mrz = 172+178+111 ...

Re: Pivottable to diagram (rangesum)

sunny_talwar — Wed, 03 Aug 2016 17:51:54 GMT

Avg({1}0) allows us to keep the forecasted area of the chart disallowing any selection made to that part due to {1}.

Is the accumulation part sorted out? or is that a question for me?

Also, Once you get to what you want, I would ask you to close this thread down by marking correct and helpful responses so that other people coming to this thread in future can look for answers in the correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

Re: Pivottable to diagram (rangesum)

Thu, 04 Aug 2016 06:45:15 GMT

Thank you very much !!! No, it was no question, it was additional information ! Kind regard, André

Re: Pivottable to diagram (rangesum)

sunny_talwar — Thu, 04 Aug 2016 10:15:55 GMT

Awesome

I am glad we were able to help you andrekab‌