get Value of a aggregated Value and subtract them and Display them

[#1]

Hey guys im new to qlikview so pleas help me.

How do i get the aggregated value of total and total2 out of this diagramm and then subtract it and display it in a textbox?

[Gysbert_Wassenaar]

=Rangesum(Sum(total2), -sum(total))

[raghvendrasingh]

Try this one in text box:-

=sum(TOTAL (total)) - sum(TOTAL (total2))

[#4]

With your Solution qlikview doesn't recognize "total", how can i make him recognize that field?

[#5]

With your Solution qlikview doesn't recognize "total2", how can i make him recognize that field?

[Anonymous · Accepted solution]

Hi,

To remove the aggregated total from the chart, Choose "No Total" radio button in Expression tab as below,

and to show the difference between total & total2 in text box use as below,

=Sum(total)-Sum(total2)

[jagan]

Hi,

Try like this

=Rangesum(Sum(total2Expression) - Sum(totalExpression)

Hope this helps you.

Regards,

Jagan.

[#8]

I have a problem with your solution.

Qlikview doesn't recognize the fields that i want to sum.

I tried to change the names of my colums but that also didn't help.

How can i make him recoginze these?

[Gysbert_Wassenaar]

Use the correct case sensitive field names or the label names of other expressions. Use the same case sensitive names. To Qlikview Sales, SALES, sales and SaLes are four different fields.

[Anonymous]

Hi,

Please use the expression you have used in the chart for columns a & b and not the column name a,b.

Example,

In the above screenshot I have used Sum(Col3) for Col3 and Sum(Col5) for Col5, so to find the difference between Col3 and Col5 we need to calculate as Sum(Col3)-Sum(Col5)