topic Re: Calculating Variance as a Dimension in Straight table in QlikView

Calculating Variance as a Dimension in Straight table

sindhura — Tue, 16 Aug 2016 21:05:33 GMT

Hi all,

I have a scenario where I need to calculate the variance and populate as a Dimension

For ex:

i need to populate data as shown in the below Picture. I have each color as my dimension and i have measures Cost, Weight and Count

Now I need to calculate variance variamce = total-(red + blue+ black+brown+Yellow+Pink+Green).

Kindly reply asap.

Thanks in advance

Re: Calculating Variance as a Dimension in Straight table

sunny_talwar — Tue, 16 Aug 2016 23:54:56 GMT

Is this a straight table or pivot table you are looking to get this done in?

Re: Calculating Variance as a Dimension in Straight table

trdandamudi — Wed, 17 Aug 2016 02:19:14 GMT

May be as below: (Please see the attached for the .qvw file)

Re: Calculating Variance as a Dimension in Straight table

sindhura — Wed, 17 Aug 2016 14:00:45 GMT

looking to do in Stariaght table.

Re: Calculating Variance as a Dimension in Straight table

sindhura — Wed, 17 Aug 2016 14:01:20 GMT

But we might not get always Zeros for the Variance

Re: Calculating Variance as a Dimension in Straight table

trdandamudi — Wed, 17 Aug 2016 15:46:38 GMT

Can you provide a sample where you get a variance ? So that it will help us to get a solution..

Re: Calculating Variance as a Dimension in Straight table

sindhura — Wed, 17 Aug 2016 17:50:41 GMT

I am not Sure. We will do Expression total as Total Mode under Expression tab for each expression. Thereby it calcultes the Total Field. And the Cost, Weight fro each dimension will be calculated and atlast Variance need to be done.

Re: Calculating Variance as a Dimension in Straight table

sindhura — Thu, 18 Aug 2016 00:01:05 GMT

It worked.

Thanks

Re: Calculating Variance as a Dimension in Straight table

trdandamudi — Thu, 18 Aug 2016 00:42:31 GMT

Ok. Glad able to help you...