Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkluca82
New 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

Re: Display only certain values on a filter pane

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
New Contributor III

Re: Display only certain values on a filter pane

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

Re: Display only certain values on a filter pane

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.