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: 
jmialoundama
Specialist
Specialist

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 (2)
9 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
jmialoundama
Specialist
Specialist
Author

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

Anil_Babu_Samineni

May be using this with Show If condition?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
jmialoundama
Specialist
Specialist
Author

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.

sunny_talwar

Can you try this

=SubStringCount(Concat(DISTINCT '|' & [CODE DC 15] & '|'), '151200') = 1
jmialoundama
Specialist
Specialist
Author

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

sunny_talwar

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

jmialoundama
Specialist
Specialist
Author

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 

sunny_talwar

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