Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulated in chart

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:

                                                                                                                                                                                          

YEARMONTHTOT_YEARMONTHACUMULATED
201306895895
20130710851980
2013089502930
20130912204150
20131012045354
20131110426396
20131213427738
2014018648602
2014029609562
20140395710519
201404115911678
201405130412982
201406115314135
201407118515320
201408110216422
201409141617838
201410160319441
201411118120622
201412141822040
20150151222552

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

                                                                                                          

YEARMONTH TOT_YEARMONTH ACUMULATED
2014018648602
2014029609562
20140395710519
201404115911678
201405130412982
201406115314135
201407118515320
201408110216422
201409141617838
201410160319441
201411118120622
201412141822040
20150151222552

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

YEARMONTH TOT_YEARMONTH ACUMULATED
20130912204150
20131012045354
20131110426396
20131213427738
2014018648602
2014029609562
20140395710519
201404115911678
201405130412982
201406115314135
201407118515320
201408110216422
201409141617838
9 Replies
Anonymous
Not applicable
Author

sujeetsingh
Master III
Master III

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

Not applicable
Author

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

sunny_talwar

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

Best,

S

Not applicable
Author

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

sunny_talwar

Is this what you are looking for? PFA

Best,

S

Not applicable
Author

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

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

Best,

S

Not applicable
Author

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