topic Re: row wise sum in QlikView

row wise sum

Wed, 04 Nov 2015 12:21:53 GMT

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

Re: row wise sum

Anonymous — Wed, 04 Nov 2015 12:25:29 GMT

Try this one:

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

/

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

Re: row wise sum

Wed, 04 Nov 2015 12:49:22 GMT

excellent thanks:)