topic Subtotal by only 1 expression in QlikView

Subtotal by only 1 expression

qlikviewaf — Thu, 26 Mar 2020 10:18:21 GMT

Hi,

i build the following table, as you can see we have 3 expressions: Revenue / Surgery / ASP.

How i can add a total by customer only for Revenue? If i turn on subtotal using table-proprierties, the subtotal will appear for all the 3 expression, and i would like to have it only for revenue.

THank you

Re: Subtotal by only 1 expression

Brett_Bleess — Tue, 21 Apr 2020 17:55:24 GMT

I do not know that it is possible to do what you want to do, I would suggest having a look at the following Design Blog post though, as that may provide another option in a separate chart.

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Regards,
Brett