Using Set analysis to r-use a reference value

[#1]

Hello,

My reference table is :

I want to use the result of ‘Correl Ref’ calculated in  2013 in the 2014 Data for the same REGION and Product, but I am not able, as you can see below

Here is the expected result:

I have attached the QVW, could someone help me please

Regards,

[sundarakumar]

Hi,

As qlikview is using associative logic, i think it is not possible in qlikview.

-Sundar

[#3]

I still have a hope that there is a solution somewhere

This thread is close to my issue but Calculate with reference value per dimension - Please HELP!

[#4 · Accepted solution]

It is actually possible:

Sum(total <REGION,Product> {<Year={'2013'}>}  Bill) / Sum(total <REGION,Product> {<Year={'2013'}>} Production)

[#5]

It is possible, I tried with your app. You just need to remove the Year dimension from chart and then use.

Please see the attached.

Thanks,

Angad

[#6]

Wonderful Thank you Francis Everything is possible