Exclude a measure from Total

gourpros — Sat, 16 Nov 2024 05:37:58 GMT

Dear Qlik Experts

I have 2 input tables

Region	Sales
Asia	100
Europe	100
America	100
Africa	100
Latin	100

Cost Header	Amount
People	40

In output I want to exclude People cost from Group total like this

I don't want to load each of these entries including totals in script and then show them in a simple table without any totals as there are many measures to be calculated.

Any help on approach is highly appreciated.

Required Output

Asia	100
Europe	100
America	100
Africa	100
Latin	100
Group Total	500
People Cost	40
Group Total exl People Cost	460

Re: Exclude a measure from Total

Channa — Mon, 10 Jun 2019 14:50:23 GMT

select region,sales from table1

concatenate

selct costheader ,Amount from table2

topic Exclude a measure from Total in App Development

Exclude a measure from Total

Re: Exclude a measure from Total