topic Re: Alternate State - Total Variance % Issue in QlikView

Alternate State - Total Variance % Issue

Mon, 04 Jan 2016 20:59:10 GMT

Hi,

I am conducting a comparitive analysis using Alternate States comparing my Clients Average Charges to a Competitor / Group of Competitors Average Charge. Everything in the table below work fine with the exception of the Total for the Variance %. If you look at it, it states 21.3%. It should be 46.5% ($89.9M / $61.3M - 1). I understand why it doesn't work, as in I am Total Mode Expressions under the Expressions tab. Can you anyone provide guidance on an expression that will result it the correct Total Variance %. Listed below is a screen shot and a list of formulas being used in the table

Re: Alternate State - Total Variance % Issue

sunny_talwar — Mon, 04 Jan 2016 21:05:54 GMT

Your expressions seems to be right, would you be able to share the sample to play around with it?

Re: Alternate State - Total Variance % Issue

Mon, 04 Jan 2016 21:30:28 GMT

Hi Sunny,

Thanks for your response. I will upload a sample version of the file shortly.

Brian