topic removing member from dimension in QlikView

removing member from dimension

Wed, 19 Nov 2014 13:52:21 GMT

How can i not show a member in dimension, so in the example below i do not want to show 2.

Re: removing member from dimension

jpenuliar — Wed, 19 Nov 2014 14:01:38 GMT

try a calculated dimension: =if(field<>2,field)

Re: removing member from dimension

PradeepReddy — Wed, 19 Nov 2014 14:02:11 GMT

Try something like this..

In List box, Add an expression instead of field.. If(MBR<>'2',MBR)

Re: removing member from dimension

Wed, 19 Nov 2014 14:04:16 GMT

Hi,

if(match(field,'2')=0,field)

regards

Harshita Gaur

Re: removing member from dimension

jpenuliar — Wed, 19 Nov 2014 14:04:37 GMT

you can also use Valuelist('1','4','3')

Re: removing member from dimension

Wed, 19 Nov 2014 14:06:20 GMT

Hi,

try this

if(not match(member,2),field)

Re: removing member from dimension

Wed, 19 Nov 2014 14:09:26 GMT

thanks all that worked

Re: removing member from dimension

PradeepReddy — Wed, 19 Nov 2014 14:12:04 GMT

Close the thread..

Re: removing member from dimension

Wed, 19 Nov 2014 14:13:06 GMT

how

Re: removing member from dimension

jagan — Wed, 19 Nov 2014 14:13:20 GMT

Hi,

Try this calculated dimension

=If(DimensionName<>2,DimensionName)

The best approach handle this in script, calc dimensions has performance issues.

LOAD

If(DimensionName<>2,DimensionName) AS NewDimensionName

FROM DataSource;

Now use NewDimensionName as dimension.

Regards,

Jagan.

Re: removing member from dimension

Wed, 03 Dec 2014 16:58:31 GMT

In the above example, if i dont want to show 2 and 3 how would i extend this?

Re: removing member from dimension

salto — Wed, 03 Dec 2014 17:06:52 GMT

Hi,

what about adding an "or" condition to the calculated dimension...

=if(field<>2 or field<>3,field)

Re: removing member from dimension

Wed, 03 Dec 2014 17:12:48 GMT

the or statement left them both in so used the and and that worked.

thanks

Re: removing member from dimension

its_anandrjs — Wed, 03 Dec 2014 17:14:49 GMT

Hi,

You can write also

=if(not Match(field,2,3),field)

Regards

Anand

Re: removing member from dimension

salto — Wed, 03 Dec 2014 17:15:03 GMT

Oops, my fault I wrote too fast!