Discussion board where members can get started with Qlik Sense.
i'm trying to filter some values on a filter pane with a expression like this:
It works, but instead of selecting only the FIELD3 on the top active filter it select also FIELD2.
In another example:
if(aggr(sum(FIELD1),FIELD2)>0,FIELD 3 & ' ---- ' & FIELD4,
it will add also FIELD4 on the active selections...
how can avoid this? I want only to have on the top active selections the FIELD3
I would suggest doing this logic in the back-end script to create a flag of sorts and put the new field in a listbox.
if i create a new field like: FIELD 3 & ' ---- ' & FIELD4 as NewField
i get rid of FIELD4, but the problem is in the first scenario, i want to get rid of FIELD2 used in the AGGR function
Perhaps use an if statement outlining the same logic in the back-end script to create a new field which you can then reference in a list box. In that way, you keep the integrity of the original data as well.