topic Re: Help with filtering with set analysis in App Development

Help with filtering with set analysis

josemaria_cabre — Thu, 03 Jan 2019 13:43:37 GMT

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.

Re: Help with filtering with set analysis

skamath1 — Thu, 03 Jan 2019 13:59:06 GMT

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/SetAnalysis/set-modifiers.htm

Re: Help with filtering with set analysis

bgerchikov — Thu, 03 Jan 2019 20:13:36 GMT

Try this:

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

Good luck!

Re: Help with filtering with set analysis

josemaria_cabre — Fri, 04 Jan 2019 08:35:23 GMT

Your solution works perfect!

Thanks a lot for your help.

Best regards,
Jm