Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Hide a certain value of Dimension?

I have data that broken down by Month. How do I hide a certain value, e.g. September from the Month dimension?

Tags (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Hide a certain value of Dimension?

Hi there.

See example attached.

Kind regards,

Ernesto.

8 Replies

Re: Hide a certain value of Dimension?

Maybe a Calculated Dimension something like :

     if ( num(Month) = 9 , Month , null() )

vinafidalgo
Contributor

Re: Hide a certain value of Dimension?

Can you upload your QVW?

Re: Hide a certain value of Dimension?

I did not create a qvw, I just typed the Calculated Dimension freehand.

vinafidalgo
Contributor

Re: Hide a certain value of Dimension?

I meant to the author of this post.

I guess your solution is propably right.

Partner
Partner

Re: Hide a certain value of Dimension?

Hi there.

See example attached.

Kind regards,

Ernesto.

Not applicable

Re: Hide a certain value of Dimension?

Hi Vinicius,

Sorry, my QVW contains confidential information so I can't post it. Thank you.

Not applicable

Re: Hide a certain value of Dimension?

Hi Ernesto,

This is perfect, thank you!

Best Regards,

Jason

Not applicable

Re: Hide a certain value of Dimension?

Hi Bill,

Thanks! I couldn't get this to work but I was able to use Ernesto's example below.

Best Regards,

Jason