Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Highlighted
Partner
Partner

Exclude a measure from Total

 

Dear Qlik Experts

I have 2 input tables

RegionSales
Asia100
Europe100
America100
Africa100
Latin100

 

Cost HeaderAmount
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
  
Asia100
Europe100
America100
Africa100
Latin100
Group Total500
People Cost40
Group Total exl People Cost 460
Labels (1)
1 Reply
Channa
Valued Contributor III

Re: Exclude a measure from Total

select region,sales from table1

concatenate

selct costheader ,Amount from table2

Channa