topic Re: Division of expression in QlikView

Division of expression

Tue, 09 Aug 2011 15:56:44 GMT

Hi, I'm not able to complete this simple task: build a new expression as a division of two existing progressive expressions.

Suppose I have a table like this:

Month Amount Margin

1 300 12

2 150 3

3 220 45

I need to calculate a column called "Progressive spread" equal to the progressive sum of Margin diveded by the progressive sum of Amount.

The result should be:

Month Amount Margin Progressive amount Progressive margin Progressive spread (<= this is what I need)

1 300 12 300 12 12 / 300 = 4.00%

2 150 3 300 + 150 = 450 12 + 3 = 15 15 / 450 = 3.33%

3 220 45 300 + 150 + 220 = 670 12 + 3 + 45 = 60 60 / 670 = 8.96%

I've tried every combination of progressive, sum total, sum above, ... but I wasn't able to achive the goal.

Can someone help me?

Thanks in advance

Michele

Re: Division of expression

Tue, 09 Aug 2011 18:13:24 GMT

Hi Michele,

please take a look at my exam application. Note that you can use names (labels) of chart-expressions using square-brackets [].

Regards, Roland

Re: Division of expression

Wed, 10 Aug 2011 07:18:42 GMT

Thanks,

that's exactly what I need.

How can I draw the "Progressive spread" on a line graph having month as X axis?

I've tried your formula but it plot the spread of the month, not the progressive one.

Thanks again

Michele

Division of expression

Wed, 10 Aug 2011 07:41:01 GMT

Sorry for my previous post: I made it!

The problem was that in the original table I have many rows for each month and so I had to previously build two columns called "Amount total" as SUM(Amount) and "Margin total" as SUM(Margin) to use in next calculations.

Thanks for your help

Michele