Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

convert cumulative sales into monthly sales and plot in bar chart

Hi Gysbert,

Thanks for the solution,

I am getting an absurd error when using this logic. All my cumulative sales are converted into monthly sales except for year 2014 7th month. It is showing monthly values same as cumulative values. however when I checked it into excel its working fine.

Please find attached the sample file.

Please help.

Regards,

Sanjay

3 Replies

Your data for this Year month are the same:

Untitled.png

Highlighted
Not applicable

Hi Robert,

The data for this year month has been calculated by the formula. This is exactly the problem which we are facing. we have cumulative data and we are calculating monthly value out of it. but for this particular month  it is showing same value. i have no clue Y?

Highlighted

What are your expected values then?