Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to suppress blank dimension values


Hi

I have 2 dimensions to show in a chart. i.e. Ticket owner and tools handled. This needs to be shown on Y axis.

X axis I am counting the number of tickets handled. Essentially I need to show number of tickets handled by each tickets owner per application.

I would like to suppress blank values wherever there were no tickets handled by the ticket owner for a particular tool. Can anybody please advise how do i modify the dimension for it?

I am attaching my graph. I need to suppress the tools wherever its blank

18 Replies
Anonymous
Not applicable
Author

Hi Shiva

I have attached the application. Do let me kow if you need further information

sakamsureshbabu
Creator
Creator

Hi Sanjyot,

Do below thing for two dimensions

Chart Properties -> Dimensions -> tick "Suppress When Value Is Null"



buzzy996
Master II
Master II

pleas share ur app?

Anonymous
Not applicable
Author


attaching the app

PrashantSangle

Hi,

As you said you required two Dimension Ticket Owner and Ticket Impacted

but in your chart there is oner more dimension TR_Priority_Group

Just removed it if dont required. then your will get desired result.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Hi

I need Priority of the tickets as well in the dimensions to show the level of tickets worked upon by the ticket owner for a particular tool.


avinashelite

Hi Sanjyot,

I checked your qvw file your not getting any blank or null values ..since the values are less it appears to be no bar ...check the below images  i just selected the values which appear like blank ...it has very less values when compared to other so it appear like this.

c2.png

c1.png

Anonymous
Not applicable
Author

Hi

I wanted to suppress the blank ones.how do i go about it then?

avinashelite

blank values are already suppressed...do to more number of values its appearing like that ...enable scroll for 5 or 10 values and then check