Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to use expressions in TTEST_SIG function?

Hi Everyone,

I want to calculate p-value of the % of customers using each product in each of the two countries to understand if the % difference in usage of a product in each country is really significant i.e people of one country prefer a product more as compared to other country. How can I write a TTEST_SIG formula to find the % of users of each product in each country and then compare the percentages of one country with other for each product? Below is the sample data:

COUNTRYCUSTOMERPRODUCT
AC1P1
AC2P1
AC3P1
AC4P2
AC5P2
BC6P1
BC7P2
BC8P2
BC9P2
BC10P2

Thanks,

Amit

Tags (2)
Community Browser