topic Re: use calculated data from one table in another table or chart in QlikView

use calculated data from one table in another table or chart

Thu, 28 Mar 2013 16:04:31 GMT

Hi experts,

i try to create a dynamic classification in QV for article-numbers. (selected by article-type, location, ...)

I already did the classification in a straight table and now i want to use the results for further calculations.

Is it possible to transfer the result to other tables or charts?

Or to add it to the skript?

Thanks a lot

Sebastian

Re: use calculated data from one table in another table or chart

Gysbert_Wassenaar — Thu, 28 Mar 2013 17:05:31 GMT

It's not possible to reference data in other charts. You'll have to use the same expression in your second chart too. You could put that expression in a variable and use the variable instead in both charts.

Since you use a variable A to dynamically determine the classification it's not possible to calculate the classification in the script.

Re: use calculated data from one table in another table or chart

kaushiknsolanki — Thu, 28 Mar 2013 17:07:00 GMT

Hi,

have a look at the attached example.

Regards,

Kaushik Solanki

Re: use calculated data from one table in another table or chart

Thu, 28 Mar 2013 18:43:45 GMT

Hi,

thanks for your quick answer.

Unfortunately your solution doesn't work on my original .qvw because I use accumulated values for the classification as you can see on the improved test-.qvw.

Because of that I also can't put the expression in a variable.

Best regards

Sebastian

Re: use calculated data from one table in another table or chart

Thu, 28 Mar 2013 18:46:20 GMT

Hi,

thanks for your quick answer.

Unfortunately your solution doesn't work on my original .qvw because I use accumulated values for the classification as you can see on the improved test-.qvw.

Because of that I also can't put the expression in a variable.

Best regards

Sebastian

Re: use calculated data from one table in another table or chart

kaushiknsolanki — Thu, 28 Mar 2013 18:52:45 GMT

Hi,

Have a look at the application attached.

Hope this trick works.

Regards,

Kaushik Solanki

Re: use calculated data from one table in another table or chart

O11235 — Wed, 23 Jul 2014 13:00:51 GMT

Hi Kaushik, can you please provide an explanatioin to this trick?