This content has been marked as final.
Show 4 replies

Re: How can you calculate the variance of two columns in a pivot table?
Lisa Phillips Nov 7, 2018 12:04 AM (in response to Sumanth Gopi)Do you need this as a pivot table ?
You can do this in a straight table using set analysis.

Re: How can you calculate the variance of two columns in a pivot table?
Sumanth Gopi Nov 8, 2018 6:09 PM (in response to Lisa Phillips )Hi Lisa,
In a straight table would I be able to get the calculated values (as shown in the image attached earlier) in the row and the dimension in the column. When I tried to do it, straight table does not have the option to do so! Hence I used pivot table.


Re: How can you calculate the variance of two columns in a pivot table?
Jonathan Dienst Nov 7, 2018 12:23 AM (in response to Sumanth Gopi)Enable totals for the year dimension and use Dimensionality() or SecondaryDimensionality() to calculate the variance conditionally in the total column.

Re: How can you calculate the variance of two columns in a pivot table?
Sumanth Gopi Nov 8, 2018 6:10 PM (in response to Jonathan Dienst )Hi Jonathan,
I am new to Qlik sense and never used Dimensionality. Can you please help me with the syntax or the process to do it?
Thanks.


Re: How can you calculate the variance of two columns in a pivot table?
Than Mughi Nov 7, 2018 12:41 AM (in response to Sumanth Gopi)Could you attach the sample data?