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