Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
select region,sales from table1
concatenate
selct costheader ,Amount from table2