Hide empty dimension

[cuenueva]

Hello all,

I'm new to QV and have a very basic question that I'm struggling:

I have the following sample data:

and the following chart:

I want to hide the problems which are not relevant to that month and only display the problems in that month. How to achieve this?

Many thanks,

Cem

[Gross24256]

U will find a filter option in settings menu..There u can define your desired information.Thank you.Still if problem persists post here,will search more and post some different solution.Thanks.

[arpitkharkia]

May be using a Drill down dimension can help. Or you need to see all the data at once?

PFA

Let me know if it helps! 

[cuenueva]

Hi arpitkharkia,

Many thanks for your reply.

Unfortunately I can't open the attachment with my edition of QV 😕

I'd like to show you what I'm trying to achieve:

Thanks again,

[kushalthakral]

Hi

can you please share your sample Qlikview file

Thanks

Kushal 

[cuenueva]

Hi Kushal,

pfa

many thanks

[asinha1991]

did you try ticking suppress zero values under presentation tab?

another option is to have  calculated dimension like this(for topic)

aggr(if(yourexp>0,topic),[months],[topic])

[cuenueva]

Thank you Asinha.

Yes I suppress zero values.

I also tried aggr but no chance. I get the same result.

Maybe the nature of my question is maybe wrong. Because If I hide certain dimension from one month, I can't view them for another month. It's maybe stupid but I wanna hide the dark grey spots in the following view so to say which is a pointless task 😄