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