topic Re: Qlik Sense Set Analysis in App Development

Qlik Sense Set Analysis

Anonymous — Wed, 02 Apr 2025 17:46:37 GMT

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)

Re: Qlik Sense Set Analysis

MatheusC — Wed, 02 Apr 2025 18:25:56 GMT

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

Re: Qlik Sense Set Analysis

Anonymous — Wed, 02 Apr 2025 19:57:27 GMT

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.

Re: Qlik Sense Set Analysis

AJDoc31 — Thu, 03 Apr 2025 01:48:20 GMT

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

SUM({<IsInNetwork=>}Quantity)

Re: Qlik Sense Set Analysis

Anonymous — Thu, 03 Apr 2025 15:00:28 GMT

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

Re: Qlik Sense Set Analysis

TcnCunha_M — Thu, 03 Apr 2025 15:05:08 GMT

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

Re: Qlik Sense Set Analysis

AJDoc31 — Thu, 03 Apr 2025 15:29:22 GMT

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

Re: Qlik Sense Set Analysis

MatheusC — Fri, 04 Apr 2025 12:50:04 GMT

@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)