Correlation Analysis on two columns of a Pivot Chart

[#1]

I need help in figuring out a way to do a correlation analysis on two columns of a Pivot Chart.

I have following two dimensions in my dataset

1. Trade Date

2. Exchange ( this has values like NYSE, NASDAQ, CME, etc)

and the Measure is

1. Trade Value ( numeric)

Question -

I created a Pivot chart on the above mention dataset. It looks something like below.

Is there an easy way to perform a correlation analysis on two columns of a Pivot Chart???

I want to perform Correl(NYSE, NASDAQ). These two columns are field values of the Dimension - Exchange.

Trade Date	NYSE	NASDAQ
1/1/2014	3	2
1/2/2014	4	16
1/3/2014	5	15
1/4/2014	12	6
1/5/2014	9	14

[kaushiknsolanki]

Hi,

Have a look at the document given on below link. That will help.

Understanding Correlation Analysis and how to apply to Qlikview.docx

Regards,

Kaushik Solanki

[awhitfield]

Hi,

check out this link:

https://community.qlik.com/docs/DOC-7855

Andy

[awhitfield]

You just beat me to it!

[sunny_talwar]

This?

[kaushiknsolanki]

Haha,

Doesnt matter who beats whom. What matters is that Vaibhav gets the help he is seeking for.

Regards,

Kaushik Solanki

[#7]

This works only if you have two measures.

My issue is that I need correlation on same measure but on difference values of the dimension, aggregated by Trade date.

[kaushiknsolanki]

Then you should use the Generic load in script to create a separate field for each value of your dimension.

Help in Generic load.

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

Sample Generic Load Script

Regards,

Kaushik Solanki

[#9]

I have 100 Million + rows

Not sure if my laptop can handle two similar version of such a huge data at the same time.

[sunny_talwar]

Perform the Correl in the script? Does it have to change based on selections? I don't see another way to do correlation unless I have not been exposed to it .

Also, is the output what you want or no?