topic Re: How to exclude the field values? in QlikView

How to exclude the field values?

Anonymous — Fri, 10 Apr 2015 05:58:45 GMT

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.

Re: How to exclude the field names?

nagarjuna_kotha — Fri, 10 Apr 2015 06:04:13 GMT

Hi Nisha,

Try this..

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

Regards,

Nagarjuna

Re: How to exclude the field names?

pokassov — Fri, 10 Apr 2015 06:04:59 GMT

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

Re: How to exclude the field values?

stabben23 — Fri, 10 Apr 2015 06:05:16 GMT

Hi,

in chart use set analysis in your exression like

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

Re: How to exclude the field values?

PrashantSangle — Fri, 10 Apr 2015 06:05:37 GMT

Hi,

Use conditional dimension,

try below,

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

and check supress null

Regards

Re: How to exclude the field values?

Anonymous — Fri, 10 Apr 2015 06:53:38 GMT

Hi All,

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

Re: How to exclude the field values?

jagan — Fri, 10 Apr 2015 07:01:43 GMT

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.