Show certain values in filter pane

[jmialoundama]

Hi, 

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

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

It's doesn't works. 

Thanks for your help 🙂

[Anil_Babu_Samineni]

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

[jmialoundama]

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)

[jmialoundama]

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]

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]

Hi , 

My filter pane with differents code : 

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

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