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: 
FleetingImage
Contributor II
Contributor II

Filter pane not working when using an if statement

Hi community,

 

I've applied an if statement within a filter pane, like this (let's call the filter pane = bands):

=Pick(Match(Level,'first','second'),band_first,band_second)

Level was created like this:

levelView:
LOAD
*
INLINE [
Level
first
second
];

And then used in a filter pane, so "bands" is bound to "Level" 

The filter elements in "bands" look like this:

FleetingImage_0-1628565685901.png

 

The problem is that when I click on the filter's elements is not actually applying the filter....

I have also tried something like this:

=aggr(if(Level='first',band_first,band_second),band_first)

Even though this is working, it has a problem which is that I'm always aggregating using band_first

It looks like the problem is what I'm "passing" to the filter pane....

Thanks for your help

 

 

 

 

 

 

 

Labels (4)
2 Replies
MayilVahanan

HI

Implement this logic in the script and bring the new field and use it in the front end Pick(Match(Level,'first','second'),band_first,band_second) as NewFieldname

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
FleetingImage
Contributor II
Contributor II
Author

Hi Mayil,

Thanks for your reply.  "Level" is also a filter which could take the values first/second so my filter pane is dependent on that one.  I made an update on my question to make it clear

Regards