Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor III

Show certain values in filter pane

Hi, 

I have a filter where i want to show certain value, only value begining by '15*'. 

Capture.JPG

 

 

 

 

 

 

 

 

 

I use function WILDMATCH like that : If(WildMatch([CODE DC 15], '15*'),[CODE DC 15])

It's doesn't works. 

 

Thanks for your help 🙂

Labels (3)
9 Replies
Highlighted

Re: Show certain values in filter pane

Is that image with the same condition, For me that is correct.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III

Re: Show certain values in filter pane

Thanks for your feedback.

It works, I just put my formula in the wrong place

Thanks for your feedback.

I would also like to know how to display a column when the user selects the code 151200.

I tried this as a formula:

=wildmatch(getfieldselections([CODE]),'*151200*')=1;

It works when my filter pane does not contain the formula "IF WILDMATCH ..."

However when my filter pane contains the formula which allows you to filter on codes that start with 15, my column no longer appears.

I have the impression that when there is an expression in the column it is not possible to display a hidden column when the user selects the number 151200

Highlighted

Re: Show certain values in filter pane

May be using this with Show If condition?

If(wildmatch([CODE],'*151200*'), 1,0)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III

Re: Show certain values in filter pane

In fact my expression works well in my filter pane.

If(WildMatch([CODE DC 15], '15*'),[CODE DC 15])

However I have a table with several columns.
I would like to display column A when the code 151200 is used.

So I put this expression at the level of my column:

=wildmatch(getfieldselections([CODE]),'*151200*')=1;

But this expression does not work.

Highlighted

Re: Show certain values in filter pane

Can you try this

=SubStringCount(Concat(DISTINCT '|' & [CODE DC 15] & '|'), '151200') = 1
Highlighted
Contributor III

Re: Show certain values in filter pane

Hi , 

I try but it's doesnt works. 

I have the impression that it is not possible to display a column when you are already carrying out a filter pane.

In my filter pane I recover the code which starts with 15

However when I want to show a hidden column by telling it it doesn't work.

I would like the column to appear when the user selects a value in the CODE dimension, but I can't

Highlighted

Re: Show certain values in filter pane

Would you be able to share a sample where we can see this?

Highlighted
Contributor III

Re: Show certain values in filter pane

Hi , 

My filter pane with differents code : 

Capture1.JPG

When user selected code 151200 , the next measure appear and i use this code for appear the measure when user selected 151200 

=index(concat(distinct [CODE DC 15],','),'151200')=1

Capture.JPG

 

In my filter i want to show only code begining by '15*' 

But when i use the wildmatch fonction in filter pane like this : 

=If(WildMatch([CODE DC 15], '15*'),[CODE DC 15])

My measure ,  DOTATION 681520 doesn't appear 

Highlighted

Re: Show certain values in filter pane

That is strange that it doesn't work, but can you create a new field in the script using this same logic

If(WildMatch([CODE DC 15], '15*'), [CODE DC 15]) as [CODE DC 15 New]

and now use this new field as your filter and this as your condition

=Index(Concat(DISTINCT [CODE DC 15 New], ','), '151200') = 1