Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gourpros
Partner - Contributor II
Partner - Contributor II

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 (2)
1 Reply
Channa
Specialist III
Specialist III

select region,sales from table1

concatenate

selct costheader ,Amount from table2

Channa