Discussion board where members can get started with Qlik Sense.
I have a straight table with Territory Numbers and some Measures like Sum(unit sales),Sum(inventory Units).
Now I need to sum the Total based on selection and simultaneously display entire Table.
My straight Table is :
How can we achieve this dynamically i.e up on selection it has to sum up and also display other rows
Really appreciate your kind help
what's your goal?
Are you expecting above result?
If(Territory No=1 orTerritory No=2,'1+2',
If(Territory No=4 or Territory No=5,'4+5'))) as [New Territory No]
[New Territory No] as dimension
Sum(unit sales) as measure1
Sum(inventory units) as measure2
Please mark if its helpful.
When User selects combination of territory(for ex : 1,2) it shd display as 1+2 with other territories as well in the straight table.
And user has multiple combinations of those(for ex: 3+4 or 5+7) and they are not fixed .
We need to get 1+2 as well as other territories which are single(i mean not selected) and they have multiple combinations like 3+4 or 5+7 which are not fixed.
I did that but those territory combination is not fixed .They are dynamic.
can any one atleast let me know if such a simple requirement would able to be achieved in Qlik?