Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mogaka1234
Contributor
Contributor

Distributing monthly values

I have sales values for Jan to Dec. February value is a summation of January and February, ....December value is a summation of all the 12 months values. I need to plot month by month actual value. Please help.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Perhaps like this: Rangesum(Sum(Amount),Above(sum(Amount*-1)))


talk is cheap, supply exceeds demand
mogaka1234
Contributor
Contributor
Author

what *1?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, Amount*-1


talk is cheap, supply exceeds demand