How to exclude the field values?

[Anonymous]

Hi All,

I have one one field name called "Job board". In that so many field values are there but i have to exclude those field values which i mentioned below in points:

1. Any job board that begins with the character of string "Free_" (Need to be excluded)

2. any job board that begins with the character of string "Compliance_"(Need to be excluded)

3. Any Job board that begins with the character of string "States_"(Need to be excluded)

I have to do in charts (in dimension)

Anyone suggest me how to do this?

Thanks,

Nisha.

[nagarjuna_kotha]

Hi Nisha,

Try this..

=max({<$(=concat({<$Field-={'Year','WeekType','CalendarType'}>} '[' & $Field & ']=',','))>} WeekEnd)

Regards,

Nagarjuna

[pokassov · Accepted solution]

Hello!

1. Add Calculated Dimension

if(index( [Job board],'Free_')>0 or index( [Job board],'Compliance_')>0 or index( [Job board],'States_')>0, null(), [Job board])

2. Check "Supress when value is null"

3. Check "Lable" and write "Job board" in the next line.

Sergey

[stabben23]

Hi,

in chart use set analysis in your exression like

sum({<"Job board"-={'Free_*', Compliance_*','States_*'}>}value)

[PrashantSangle]

Hi,

Use conditional dimension,

try below,

if(not wildmatch([Job Board],'Free_*','Compliance_*','States_*'),[Job Board])

and check supress null

Regards

[Anonymous]

Hi All,

Thank you so much. All the above solutions are working. Thanks a lot.

[jagan]

Hi,

Try like this much easier and efficient

1. Add Calculated Dimension

if(Not WildMatch([Job board], 'Free_*', 'Compliance_*', 'States_*'),[Job board])

2. Check "Supress when value is null"

Regards,

Jagan.