topic Re: ratio test (significant test- ttest) in QlikView

ratio test (significant test- ttest)

Fri, 29 Mar 2013 08:48:57 GMT

Hi All,

I'm planning to use QV for marketing research.

I just wonder that; can I compare ratio's in order to whether there is significantly differences btw the periods.

For better understanding pls look sample in below, I want to compare ratios according to 95% significant level.

Periods	2012 Q1	2012 Q2	2012 Q3	2012 Q4
Ratio	55%	70%	45%	50%

Does anyone use it at QV?

Thanks in advance.

Re: ratio test (significant test- ttest)

Fri, 29 Mar 2013 09:09:12 GMT

Hi,

You can create a trend/line chart and compare these ratios against the given periods.

Use period as dimension and avg(ratio) as expression, you will get a line chart which will help you in comparing the ratio.

Hope this is helps.

Regards,

Amay

Re: ratio test (significant test- ttest)

Fri, 29 Mar 2013 10:22:23 GMT

Hi Amay,

Thanks for your reply.

It would be good graph but I want to compare ratios with significant test(%95).

In below pls you can see Output in my mind .

BR,

Cagri

Re: ratio test (significant test- ttest)

Fri, 29 Mar 2013 11:10:27 GMT

Hi Cagri,

You can use visual cues option that is present in pivot chart.

Or you can show an image instead of values based on your condition in expression.(I wont be able to provide sample app becoz qlikview is not thr on my sys )

Regards,

Amay

Re: ratio test (significant test- ttest)

Fri, 29 Mar 2013 15:10:45 GMT

Amay thanks for your kindly comments but I want to do it aoutomatically.

Re: ratio test (significant test- ttest)

Fri, 29 Mar 2013 15:20:08 GMT

I think you need to use Chi2Test_p function to do the test,