topic Re: Using Set analysis to r-use a reference value in QlikView

Using Set analysis to r-use a reference value

Fri, 14 Feb 2014 10:19:37 GMT

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 — Fri, 14 Feb 2014 11:47:29 GMT

Hi,

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

-Sundar

Fri, 14 Feb 2014 13:49:02 GMT

I still have a hope that there is a solution somewhere

Fri, 14 Feb 2014 16:05:06 GMT

It is actually possible:

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

Fri, 14 Feb 2014 16:22:23 GMT

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

Fri, 14 Feb 2014 16:26:39 GMT

Wonderful Thank you Francis Everything is possible