Question about calculated rows in straight table

[#1]

Hi, i have the following problem.

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

Dimension	Value
A	1
B	2
C	3
D	4
E	5

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

Dimension	Value
A	1
B	2
C	3
D	4
E	5
A/D	1/4
A/E	1/5

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]

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]

Perhaps this blog post helps: How IntervalMatch Solved My Profit and Loss Dilemma