topic Re: Accumulated in chart in QlikView

Accumulated in chart

Fri, 23 Jan 2015 18:29:48 GMT

I need to generate a bar chart which then accumulated for a year / month chosen by the user.

However the bar chart display only the 12 months prior to that selected, but the accumulated must be at month chosen by the user.

Full table example:

The user selects the date 201501, the chart shows the previous 12 months. But the accumulated '201306'

Or, the user selects the date 201409, the chart shows the previous 12 months. But the accumulated '201306'

Anonymous — Fri, 23 Jan 2015 18:38:05 GMT

Hi,

See link:

sujeetsingh — Fri, 23 Jan 2015 18:49:41 GMT

Bar chart has option of accumulation at the Expression tab of properties.

Fri, 23 Jan 2015 19:14:25 GMT

yes, but accumulates the values are within the chart... I need to accumulate at 201306

sunny_talwar — Fri, 23 Jan 2015 19:42:29 GMT

You should try doing this in the script if the values are accumulated beginning a certain date.

Best,

Fri, 23 Jan 2015 19:52:06 GMT

But apart should be able to make other selections, for that reason I can not doing this ine the script.

sunny_talwar — Fri, 23 Jan 2015 19:55:36 GMT

Is this what you are looking for? PFA

Best,

Fri, 23 Jan 2015 20:12:27 GMT

Yes, that's what I want to get . But the problem is that the user can make other selections, why can not generate the field in the script.

sunny_talwar — Fri, 23 Jan 2015 20:13:43 GMT

What other selections can the user make? Can you elaborate.

Best,

Fri, 23 Jan 2015 20:24:36 GMT

The "ACUMULATED" field is a document counter , the user can select a supplier or a type of document, and recalculate the chart.