topic Re: Hide empty dimension in QlikView

Hide empty dimension

cuenueva — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Hide empty dimension

Gross24256 — Fri, 26 Apr 2019 07:39:05 GMT

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.

Re: Hide empty dimension

arpitkharkia — Fri, 26 Apr 2019 09:38:52 GMT

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!

Re: Hide empty dimension

cuenueva — Fri, 26 Apr 2019 10:37:38 GMT

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,

Re: Hide empty dimension

kushalthakral — Fri, 26 Apr 2019 15:19:33 GMT

can you please share your sample Qlikview file

Thanks

Kushal

Re: Hide empty dimension

cuenueva — Sat, 27 Apr 2019 15:31:01 GMT

Hi Kushal,

pfa

many thanks

Re: Hide empty dimension

asinha1991 — Mon, 29 Apr 2019 04:57:15 GMT

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])

Re: Hide empty dimension

cuenueva — Mon, 29 Apr 2019 13:06:29 GMT

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 😄