topic Re: Set Analysis not working on my text field in App Development

Set Analysis not working on my text field

mrbenass — Fri, 12 Aug 2022 12:57:40 GMT

I have a super easy set of data that I am trying to use Set Analysis on, but the Set Analysis is not working the way i would expect it to. I would expect this Set Analysis to return 0 since I have the [Survey Source Category] in my selection bar to show only 'Fudge'. What can be going wrong here. I have been using Qlik for 6 years and never seen anything like this not working before.

Count({$<[Survey Source Category]={'Branch'}>}[Survey Source Category])

I have added the dataset as well, wondering if it is a text issue or something like that?

Re: Set Analysis not working on my text field

sidhiq91 — Fri, 12 Aug 2022 13:14:22 GMT

@mrbenass in the Set Analysis When you have defined to filter the data only for 'Branch' and its value will not change based on the User Selection in the filter.

Re: Set Analysis not working on my text field

mrbenass — Fri, 12 Aug 2022 13:19:15 GMT

But the $ in the front should still respect the filters and then calculate my measure. So i would think my KPI should return 0. It does work on other fields from my original dataset but for some reason just not on this column called [Survey Source Category].

Re: Set Analysis not working on my text field

BrunPierre — Fri, 12 Aug 2022 13:58:29 GMT

@mrbenass $ in the front mean for all records in the current selection. But as @sidhiq91 explained once a filter is set within i.e. [Survey Source Category]={'Branch'} the outcome is unaffected by user selection.

Re: Set Analysis not working on my text field

mrbenass — Fri, 12 Aug 2022 13:44:02 GMT

Maybe I am not understanding.

The current selection in the app is [Survey Source Category] = 'Fudge'. How can the set analysis return the 1 record where the [Survey Source Category] = 'Branch' if the current selection can not have any records where the [Survey Source Category] = 'Branch'? The dataset is limited to only show 'Fudge' so therefore the KPI should show a 0 and not a 1. @BrunPierre

Re: Set Analysis not working on my text field

BrunPierre — Fri, 12 Aug 2022 13:48:05 GMT

@mrbenassThis will help Set analysis and set expressions

Re: Set Analysis not working on my text field

luizcdepaula — Fri, 12 Aug 2022 14:01:23 GMT

The $ in front will respect filters from other dimensions, not the same one, in this case [Survey Source Category].

If you make selections on other dimensions, you will see that it might change, if you select a value where there is no Branch as part of that data. For example, make a selection on one of those CloudCherryIDs that belong only to Fudge, you will se the KPI will be 0.

Luiz

Re: Set Analysis not working on my text field

agigliotti — Fri, 12 Aug 2022 14:03:22 GMT

Hi @mrbenass ,

Maybe this:

Count( {< [Survey Source Category] *= {'Branch'} >} [Survey Source Category] )

I hope this can help.

Regards

Re: Set Analysis not working on my text field

BrunPierre — Fri, 12 Aug 2022 14:06:39 GMT

Is the dataset limited to 'Fudge' in the entire model or just to an object?

Re: Set Analysis not working on my text field

mrbenass — Fri, 12 Aug 2022 14:05:45 GMT

Looks like you are correct, that is weird. To work around my scenario I had to create a duplicate column with the same fields on it. I will allow the user to select from one of the fields and use the other duplicate filed for the Set Analysis then. Thanks!! @luizcdepaula

Unless anyone else knows another workaround for this?

Re: Set Analysis not working on my text field

luizcdepaula — Fri, 12 Aug 2022 14:13:19 GMT

what you trying to accomplish?

Re: Set Analysis not working on my text field

mrbenass — Fri, 12 Aug 2022 14:16:19 GMT

Thanks @agigliotti , this did what i needed by adding the * to the front of the = sign. Much appreciated!