Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using Set analysis to r-use a reference value

Hello,

My reference table is :

Image1.gif

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

Image2.gif

Here is the expected result:

image3.gif

I have attached the QVW, could someone help me please

Regards,

1 Solution

Accepted Solutions
Not applicable
Author

It is actually possible:

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

View solution in original post

5 Replies
sundarakumar
Specialist II
Specialist II

Hi,

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

-Sundar

Not applicable
Author

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!

Not applicable
Author

It is actually possible:

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

Not applicable
Author

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

Not applicable
Author

Wonderful Thank you Francis Everything is possible