Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

imrasyed
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 :

Header 1Header 2Header 3
Territory NoSum(unit sales)Sum(inventory Units)
110030
220100
3500200
4300100
5200100

Expected Output:

Header 1Header 2Header 3
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

what's your goal?

Partner
Partner

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

Straight table.png

Are you expecting above result?

priyalvp24
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


test.png


Please mark if its helpful.

Thanks



imrasyed
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 .

imrasyed
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.

imrasyed
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.

imrasyed
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?