topic Re: Excluding Multiple Values from a Dimension in QlikView

Excluding Multiple Values from a Dimension

Tue, 18 Sep 2012 21:23:01 GMT

I am trying to create a dimension within a straight table that excludes multiple values. Specifically, I am trying to filter out about 20 different Test Patients from a set of data.

Is it possible to create a calculated dimension within the straight table that will filter them out, or must this be done a different way?

Keep in mind, I need them to load into the application for other tables.

Re: Excluding Multiple Values from a Dimension

Tue, 18 Sep 2012 21:29:07 GMT

You can use a calculated dimension and suppress nulls. See attached for a basic example.

Re: Excluding Multiple Values from a Dimension

MayilVahanan — Tue, 18 Sep 2012 21:39:04 GMT

Try like this,

if(not match(FieldName,'value1','value2',..,'value20'),FieldName) as dimension and suppress null value..

if excluded field value is more then displaying field value means, use match function as per your convenience..

Hope it helps

Re: Excluding Multiple Values from a Dimension

Tue, 18 Sep 2012 21:52:11 GMT

The if(not match ...) worked well, thank you.

Re: Excluding Multiple Values from a Dimension

Wed, 19 Sep 2012 04:52:18 GMT

Hai Mayli

What Is The Meaning Of Uni Testing In QLikview.