expression in total row and gauge

[#1]

Ho to all,

I've a problem with an expression on total row. You can see the file "esempio.qvw" in attach.

I'd like to get the values in "yellow boxes" on total row of pivot table and on gauge chart but I don't know wich expression to write.

I can't solve the question at script level because the example it is just a simplification of the reality.

Thanks in advance

stefano

[erichshiino · Accepted solution]

Hi, Stefano

The problem was that outside of the chart, or in total lines, QlikView would group all the values before calculating your conditions. So the sum of the results for each deposit was different from the results of the company.

I created aggr functions to reproduce the result by deposit.

[#3]

Hi Erich,

thank you very much for your answer: it's the solution that I want!