Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
It is actually possible:
Sum(total <REGION,Product> {<Year={'2013'}>} Bill) / Sum(total <REGION,Product> {<Year={'2013'}>} Production)
Hi,
As qlikview is using associative logic, i think it is not possible in qlikview.
-Sundar
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!
It is actually possible:
Sum(total <REGION,Product> {<Year={'2013'}>} Bill) / Sum(total <REGION,Product> {<Year={'2013'}>} Production)
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
Wonderful Thank you Francis Everything is possible