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

Announcements
Join us in Bucharest on Sept 18th 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