Help with filtering with set analysis

[josemaria_cabre]

Hi everyone and Happy New Year!

I'm having some trouble with this:

Let's imagine we have the following table in Qliksense

iD              Code      CombinedID   Family     sum(Sales)

996001    AA           996001AA         Rev           100
996001    AB           996001AB         Rev           120
996002    CD           996002CD        Acc            80
996002    DE           996002DE        Acc            100

I'd like to show all 'iD' related to an specific 'CombinedID' even if a filter for 'CombinedID' is applied. So if user filters CombinedID=996001AA, I'd like to show this result in table:

iD              Code      CombinedID   Family     sum(Sales)

996001    AA           996001AA         Rev           100
996001    AB           996001AB         Rev           120

I've tried to do some set analysis with an expression like:

sum({<
CombinedID=,
Code=
>}
Sales)

but it didn't work because all results in table where shown anyway, and not only the '996001' iD ones.

Can anyone help with this, pls?

Thanks in advance,

Jose.

[skamath1]

The set analysis expression with CombinedID=  will ignore any selection made in the field CombinedID. 

You need to explore using the set modifier. Below help link can provide you required examples:

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

[bgerchikov · Accepted solution]

Try this:

sum({<CombinedID=,Code=,iD = P(iD)>} Sales)

Good luck!

[josemaria_cabre]

Your solution works perfect!

Thanks a lot for your help.

Best regards,
Jm