Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mkajandt
Contributor II
Contributor II

Calculate correlation for each row of selection

Hi,

I have a table in following format:

AccountNumber Month Value

100200               1          500

100200               2          1000

...

and I need to calculate average of correlations (based on months) between each account in the selection and the monthly sum of all selected accounts. Is that even possible? I can't think of any solution which would tell QlikSense/QV to calculate a separate correlation for each row in the selection (get the average is then simple). I would hardcode it in the script or something, but the problem is that it needs to be dynamic.

Thanks in advance, I'm really losing nerves on this one.

Cheers

Miroslav

0 Replies