Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to calculate variance?

Required

         

Year2015-162016-17VarianceGrand Total
HEADSUB HEADPaxFlightsPaxFlightsPaxFlightsPaxFlights
A1--82,371354100%100%82,371354
3--111,404457100%100%111,404457
Head Total--193,775811100%100%193,775811
B1--41,307255100%100%41,307255
3--76,686753100%100%76,686753
Head Total--117,9931,008100%100%117,9931,008
C11,351,15816,0981,396,67014,9083%-7%2,747,82831,006
21,948,87025,1102,283,29424,60617%-2%4,232,16449,716
35,292,49745,8925,621,98947,4456%3%10,914,48693,337
41,300,46510,0551,152,38310,415-11%4%2,452,84820,470
Head Total9,892,99097,15510,454,33697,3746%0%20,347,326194,529
Grand Total 9,892,99097,15510,766,10499,1939%2%20,659,094196,348

Actual

              

Year2015-162015-162015-162015-162016-172016-172016-172016-17Grand TotalGrand TotalGrand TotalGrand Total
HeadSub HeadPaxFlightsPax VarianceFlight VariancePaxFlightsPax VarianceFlight VariancePaxFlightsPax VarianceFlight Variance
A1----82,371354--82,371354--
A3----111,404457--111,404457--
AHead Total----193,775811--193,775811--
B1----41,307255--41,307255--
B3----76,686753--76,686753--
BHead Total----117,9931,008--117,9931,008--
C11,351,15816,098--1,396,67014,908--2,747,82831,006--
C21,948,87025,110--2,283,29424,606--4,232,16449,716--
C35,292,49745,892--5,621,98947,445--10,914,48693,337--
C41,300,46510,055--1,152,38310,415--2,452,84820,470--
CHead Total9,892,99097,155--10,454,33697,374--20,347,326194,529--
Grand Total 9,892,99097,155--10,766,10499,193--20,659,094196,348--
Tags (1)
8 Replies

Re: How to calculate variance?

That is possible just change and play with Partial Sum from presentation tab. If not, we will request you to share sample

Not applicable

Re: How to calculate variance?

The presentation tab has no option to calculate variance as I have mentioned under the heading REQUIRED. In QlikView how can I make expression to have variance of Pax & Flights for 02 or more than 02 years.

Not applicable

Re: How to calculate variance?

If you know the option then share it with me as sample.

Re: How to calculate variance?

I think you need some formula to get into work. May be share sample?

Re: How to calculate variance?

Hi,

In pivot table it is difficult to find variance because it is the dimension Year and for variance you have to go for the previous year or current year to calculate variance. Better if you calculate this variance in your script part (BackEnd Script) and then plot that variance on the chart.

Regards,

Anand

Re: How to calculate variance?

You can use the Dimensionality() function as well in the dimension part of the chart and use partial sum properties to arrange the sum.

Regards

Anand

Not applicable

Re: How to calculate variance?

What about straight table?

Re: How to calculate variance?

Yes right you can use it is better way but how you group the data in straight table which you shown right now. Dimension that you are using

Year, Head, Sub Head

Hope this helps

Regards
Anand