Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Creator III
Creator III

Filters valued but not chosen

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:

danosoft_0-1631800210703.png

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)

1 Solution

Accepted Solutions
danosoft
Creator III
Creator III
Author

I find the problem:

I have the trigger:

on each selection

danosoft_0-1632386163857.png

this:

danosoft_1-1632386231639.png

 

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

 

 

 

View solution in original post

11 Replies
rubenmarin

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
Creator III
Creator III
Author

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

rubenmarin

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
Creator III
Creator III
Author

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

danosoft
Creator III
Creator III
Author

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

rubenmarin

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.

rubenmarin_0-1632154343249.png

 

danosoft
Creator III
Creator III
Author

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

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
Creator III
Creator III
Author

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

danosoft_1-1632230117771.png

 

=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

danosoft_0-1632230091370.png