Solved: Filters valued but not chosen - Qlik Community

danosoft · ‎2021-09-16

If I do certain filters (for example if I choose my DES_REFERENT field) I notice that in the object where the list of filters is displayed I learn a filter that I have never put, and I would not want it, on what does this behavior depend?

For example:

it has been inserted autonomously and I would not want it, because if I change the filter in DES_REFERENTE this previous CD_FORNITORE limits me the view of the rows (which should not have selected it)

danosoft · ‎2021-09-23

I find the problem:

I have the trigger:

on each selection

this:

and in the expression i have this: =if(UPPER(OSUSER())='THISTHISTHIS','VALUE',CD_FORNITORE)

View solution in original post

rubenmarin · ‎2021-09-18

Hi, This behaviour can be caused beacuse of an Aggr() function, like Aggr(DES_REFERENT, CD_FORNITORE), this will show DES_REFERNT values but the selections will be done in CD_FORNITORE.

This value can also be set by triggers.

danosoft · ‎2021-09-20

do you mean that somewhere in some expression around there might be an AGGR function causing this behavior?

rubenmarin · ‎2021-09-20

If this is a filter that exists when the app is opened most propably it's because of a trigger, open configuration menu -> document properties ->triggers, there may be something that makes actions on start, it could be direct actions to select values or executing a macro that makes the selctions

danosoft · ‎2021-09-20

No, it is not a trigger and CD_FORNITORE is not set by anyone as a filter

danosoft · ‎2021-09-20

How can I find if there is an AGGR function in one of the expressions used (there are a lot of them)

rubenmarin · ‎2021-09-20

Is the value selected when you open the app?.

Aggr will only select values in another field when user selects a value, or by a trigger.

There is also the option that CD_FORNITORE field has the option to 'always one value selected' ebnabled, you can add a list with this field to check if it has the option enabled.

danosoft · ‎2021-09-21

Is the value selected when you open the app? NO

I DON'T have a filter that works on CD_FORNITORE, so I don't understand why it is selected if I select DES_REFERENT

so i think it may depend on an Aggr, as you said earlier, but how can i find where this Aggr expression is in the whole document?

rubenmarin · ‎2021-09-21

If it's done when you select DES_REFERENT you have to check the object where you are selecting the values to see if it's using an aggr.

This would be easier if you can upload a sample to check

danosoft · ‎2021-09-21

in the object i have this expression (the object is a listbox):

=aggr(Concat(DISTINCT {<DES_REFERENTE=P(DES_REFERENTE), DES_REFERENTE=>} DES_REFERENTE), DES_REFERENTE)

when i choose one.... it put in the selection CD_FORNITORE