Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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