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