Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gkluca82
Partner - Contributor III
Partner - Contributor III

Display only certain values on a filter pane

Hi guys,

i'm trying to filter some values on a filter pane with a expression like this:

if(

aggr(sum(FIELD1),FIELD2)>0,FIELD 3,

)

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

tnx

3 Replies
Not applicable

Hi,

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.

Regards,

Pravesh

gkluca82
Partner - Contributor III
Partner - Contributor III
Author

hi,

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

Not applicable

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.