Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
muhammadraza
Partner - Creator
Partner - Creator

how can I subtract values appearing in the same column

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable

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

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.


talk is cheap, supply exceeds demand
muhammadraza
Partner - Creator
Partner - Creator
Author

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

muhammadraza
Partner - Creator
Partner - Creator
Author

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