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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

row wise sum

SUM({<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity])))

/

((
SUM(TOTAL{<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity]))))

when I used it will total of all year ,but i need that sale should be divided by total of a particular month

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try this one:


SUM({<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity])))

/

((
SUM(TOTAL<YourMonthName>{<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity]))))

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Try this one:


SUM({<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity])))

/

((
SUM(TOTAL<YourMonthName>{<Year={'$(vMaxPostingYear)'},DateNum={'<=$(vMaxPostingDate)'}>}[Sale Quantity]))))

Not applicable
Author

excellent thanks:)