Qlik Sense Set Analysis

[Anonymous]

Hello,

Not sure if there is a difference in QlikView to Qlik Sense for Set Analysis. The example below should force the filter to always select the flag 1 and 0 regardless of a user interacting with the IsInNetwork filter then adjust the total to the other filters such as date or region or sales person.

sum({<IsInNetwork={'1','0'}>}Quantity)

If I set to this I get and the user updates the IsInNetwork filter the total changes to the selected flag to sum({$<IsInNetwork={'1','0'}>}Quantity)

[MatheusC]

Using 1 will result in the full value of your data.

And ignore any selections made by the user.


sum({1<IsInNetwork={'1','0'}>}Quantity)


- Regards, Matheus

[Anonymous]

Yes, but this is not the answer I was hoping for per my example. I want this filter to stay but adjust to other user filters.

[AJDoc31]

With choices like 1 and 0 are there ever any other options? if not you can just ignore the filter like:

SUM({<IsInNetwork=>}Quantity)

[Anonymous]

Seems like people just fish random solutions to have their solution accepted for points these days. 

[TcnCunha_M]

the correct is

sum({<IsInNetwork = , IsInNetwork={'1','0'}>}Quantity)

IsInNetwork = <---- "clear the selection user selection for this set analisys" / "ignore the selection"

in fact you don't need 1,0 you can user '*' with is get all.

 Set analysis should be like this 

sum({<IsInNetwork = , IsInNetwork={'*'}>}Quantity)

i will say is awkward filter work properly in QlikView, because i always sue like this in QlikView and sense the concept of set analysis is the same, this doesn't changed 

[AJDoc31]

Seems like people just post questions in the community without doing any research these days.

[MatheusC]

@Anonymous 

if you need other selections made by the user, outside of the filter applied in set analisys. Then this should work together with GetSelectedCount()


Sum({<IsInNetwork={'1', '0'}>} Quantity
) * If(GetSelectedCount(IsInNetwork) = 0, 1, 0) +
Sum(
Quantity
) * If(GetSelectedCount(IsInNetwork) > 0, 1, 0)