topic Can I hide expression only for some specific dimension value? in QlikView

Can I hide expression only for some specific dimension value?

uacg0009 — Tue, 12 Apr 2016 10:28:13 GMT

Hi Guys,

I just want to know can I hide expreesion only for some specific dimensnion value?

Now I have example data :

What I create is :

But what I want is that I don't want to see the sum(PEOPLE) for VEN='AAA'

it should be like :

VEN	AAA	BBB	BBB	CCC	CCC
BOSS	SALES	SALES	PEOPLE	SALES	PEOPLE
HAHA	100	200	4	-	-
LOL	300	400	6	500	7

I try to use condition to limit this, but it didn't work, and I think maybe macro can do this, but it's hard for me, 'cause I don't know how to use VB.

So do you know how to solve that? or any other way to do that?

Thanks.

Aiolos Zhao

Re: Can I hide expression only for some specific dimension value?

swuehl — Tue, 12 Apr 2016 10:34:29 GMT

I believe you can't remove or hide an expression column only for specific dimension values.

You could maybe change the text color.

Re: Can I hide expression only for some specific dimension value?

Gysbert_Wassenaar — Tue, 12 Apr 2016 10:34:39 GMT

See attached example.

Re: Can I hide expression only for some specific dimension value?

vikasmahajan — Tue, 12 Apr 2016 10:37:08 GMT

PFA

Vikas

Re: Can I hide expression only for some specific dimension value?

uacg0009 — Wed, 13 Apr 2016 01:36:56 GMT

Thanks for reply, and I just want to do a brainstroming, so maybe we can find another way to solve this.

Thanks.

Aiolos Zhao

Re: Can I hide expression only for some specific dimension value?

uacg0009 — Wed, 13 Apr 2016 01:37:46 GMT

Thanks for reply, but I can't see the VEN='AAA' in your qvw, actually I need to see AAA in table.

Thanks.

Aiolos Zhao

Re: Can I hide expression only for some specific dimension value?

uacg0009 — Wed, 13 Apr 2016 01:44:34 GMT

Hi Gysbert,

Well, you are my idol, always, that's so cool! And thank you so much.

But the real data is a little complex, so I need to try to make a large table to stroe these expression names.

Thanks again!

Aiolos Zhao