topic Re: Cummulative Ratio in Bar Chart with multiple Dimension in QlikView

Cummulative Ratio in Bar Chart with multiple Dimension

swatitomar — Wed, 13 Jan 2016 06:24:31 GMT

Hello All,

I want to calculate ratio i.e. Cummulative claim/cummulative wholeale with multiple dimesnion that is Model and yearmonth in bar chart..

when i select sinlge Model from list box then value comes ok but when i select multiple brands then its not working fine...

Its working ok in Pivot Table(with before() ) but when i tried in line chart(with before() ) its showing wrong value..

=(rangesum(Above(total count(claim_no)0,24))

/
rangesum(Above(total count(wholesale),0,24)))*100

please help....

thanks in Advance

Swati

sunny_talwar — Wed, 13 Jan 2016 13:27:45 GMT

It must be because of the sorting difference. Would you be able to share a sample showing the problem your facing?

swatitomar — Mon, 18 Jan 2016 09:21:28 GMT

Yes Sunny you are right that was bcoz of sorting issue..

I correct it now its working ok..

Thanku for suggesting ..

sunny_talwar — Mon, 18 Jan 2016 11:15:58 GMT

Awesome

Would you be able to close this thread by marking correct and/or helpful answers?

Best,

Sunny