Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Highlighted
Specialist III
Specialist III

select region,sales from table1

concatenate

selct costheader ,Amount from table2

Channa