topic Re: Question about calculated rows in straight table in QlikView

Question about calculated rows in straight table

Wed, 17 Jun 2015 13:19:16 GMT

Hi, i have the following problem.

In my model I have a table with the following data:

Now i want a straigth table in QlikView, which should look like this

The formular for value is sum(Value). I can't do the calculation in the Datamodel because sum(value1)/sum(value2) != sum(value1/value2)

Thank you for your help!

sinanozdemir — Tue, 08 Sep 2015 19:14:48 GMT

Hi,

This is probably not the way that you want to solve this issue, but I wanted to give a try anyway. I handled everything in the load script:

After that the data model looked like the below:

And finally the straight table or table box:

Hope this helps.

Gysbert_Wassenaar — Wed, 09 Sep 2015 05:38:22 GMT