Re: Accumulated in chart - Qlik Community

Report Inappropriate Content · ‎2015-01-23

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 · ‎2015-01-23

Hi,

See link:

sujeetsingh · ‎2015-01-23

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

Report Inappropriate Content · ‎2015-01-23

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

sunny_talwar · ‎2015-01-23

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

Best,

S

Report Inappropriate Content · ‎2015-01-23

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

sunny_talwar · ‎2015-01-23

Is this what you are looking for? PFA

Best,

S

Report Inappropriate Content · ‎2015-01-23

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 · ‎2015-01-23

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

Best,

S

Report Inappropriate Content · ‎2015-01-23

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