Discussion Board for collaboration related to QlikView App Development.
I am trying to create a pivot table that has dimensions as Sector, Zone and station as hierarchy.
I am using the TTest_sig() function to calculate significance value.
However, it does not work for me unless I create 3 different data sets one for Sector, one for Zone and one for Station.
Original Data Set:
Will the TTest_sig work currectly only when I have three different data sets like below?
Group by Sector data set
Group by Zonedata set
I get different results when calculating the TTest for the same data set but grouped differently. Please see the attache sample file.
Does this mean I have to create different set of data (as grouped above) to get correct results?
Can anyone please help me with my request ?
Thanks in advance.
Can you please help me with the above request?
I tried to use the SUM() in the function but it does not work.