how can I subtract values appearing in the same column

[muhammadraza]

Hello,

I have a straight table (plz see attached excel file), I need to achieve the third column by subtracting values in the same column, please guide how can I achieve this thing in Qlikview.

Regards,

Muhammad Raza

[#2]

In your load script you can make a calculation like this:

if(Type = 'total', values, 0) as Total_value,

if(Type = 'income', values, 0) as Income_value

etc..

In your calculation you can subtract Total_value - Income_value

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. There is no way to merge the cells though, so you'll see the value repeated on every row of the product.

[muhammadraza]

thanks for the prompt reply, but what should be done if I need to divide these two values instead of subtraction.

[muhammadraza]

thanks, but I need to do it only via table chart way using some expression