topic Re: calculated dimension to filter values in QlikView

calculated dimension to filter values

surajap123 — Thu, 22 May 2014 09:44:35 GMT

Hi All,

I am trying to create a calculated dimension to show only few values in straight table.

In the Name field, I want to filter any value starting with *classic. Eg- *Classic Edu, *Classic Tours, *Classic Agen etc..

But the below expression is still showing them. It filters out the above values only when i put full name like *Classic Edu. But i want to filter out all when Name start with *Classic in my straight table.

Below is the calculated dimension i am using-

=if(Name<>'*Classic*',Name)

Re: calculated dimension to filter values

maxgro — Thu, 22 May 2014 09:48:42 GMT

if(wildmatch(Name, '*classic*'), null(), Name)

Re: calculated dimension to filter values

senpradip007 — Thu, 22 May 2014 09:55:27 GMT

Use if(not WildMatch( Name,'*Classic*'),Name) and check "Suppress When Value Is Null"

Re: calculated dimension to filter values

its_anandrjs — Thu, 22 May 2014 10:09:42 GMT

You can try with

if(wildmatch(Name, '*classic*'), 0, Name)

if(wildmatch(Name, '*classic*'), null(), Name)

And Check the "Suppress when value is null" option in the chart

Re: calculated dimension to filter values

amit_saini — Thu, 22 May 2014 10:15:17 GMT

Hi Suraj,

Try this:

I'm taking example of year, suppose you want to display only 10,11 and 12 than use this

=if(match(Year,'2010','2011','2012' ),Year)

Thanks,

Re: calculated dimension to filter values

surajap123 — Thu, 22 May 2014 10:40:05 GMT

Thanks everyone !!