New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

Summing Based on Selections for Multiple combinations of Dim values

Hi Experts,

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.

Ex:

My  straight Table is :

Territory NoSum(unit sales)Sum(inventory Units)
110030
220100
3500200
4300100
5200100

Expected Output:

Territory NoSum(unit sales)Sum(inventory units)
1 + 2120130
3500200
4+5500100

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

Thanks

Syed Imran

7 Replies
Partner

Partner

Re: Summing Based on Selections for Multiple combinations of Dim values

Are you expecting above result?

Contributor

Re: Summing Based on Selections for Multiple combinations of Dim values

Hi,

Try this,

Script Level.

If(Territory No=1 orTerritory No=2,'1+2',

If(Territory No=3,'3',

If(Territory No=4 or Territory No=5,'4+5'))) as [New Territory No]

front end.

table object.

[New Territory No] as dimension

Sum(unit sales) as measure1

Sum(inventory units) as measure2

Thanks

Contributor

Re: Summing Based on Selections for Multiple combinations of Dim values

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 .

Contributor

Re: Summing Based on Selections for Multiple combinations of Dim values

Nop,

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.

Contributor

Re: Summing Based on Selections for Multiple combinations of Dim values

Hi,

I did that but those territory combination is not fixed .They are dynamic.

Thanks.

Contributor

Re: Summing Based on Selections for Multiple combinations of Dim values

can any one atleast let me know if such a simple requirement would  able to be  achieved in Qlik?