how to suppress blank dimension values

[Anonymous]

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

[sifatnabil]

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

Additionally, ensure Chart Properties -> Presentation tab -> "Suppress Zero-Values" and "Suppress Missing" is ticked.

[buzzy996]

u can try tis way,

try to generate null values wherever ur dimension values are zero in the above graph,then use suppress null values check box from dimension tab.

tht helps else pls share ur .qvw!

[Anonymous]

Hi

I have already done that but it doesnt seem to work..is there any other option?

[avinashelite]

try like this :

In the dimension where your getting the null values use this expression:

if(len(trim(required_dimension))=0,null(),required_dimension)

then in the chart properties >presentation > check the suppress null and suppress zero values

Hope this helps you

[buzzy996]

try the above solution suggested by me,tht will work.

[Anonymous]

Hi Shiva

my expression is count(tickets)

my dimensions are Ticket_Owners & Tool_Impacted.

when i use the below if(len(Trim(Tool_Impacted))=0,null(),Tool_Impacted) in calculated dimensions i dont find any change in the graph despite suppressing null and zero values.

if I use if(count(Tickets)>0, Tool_Impacted) in the calculated dimension it throws an error. Can tell me whats going wrong in my dimension?

[avinashelite]

count() function you cannot use like this directly in the calculated dimension ...

share your app will provide you the solution

[Anonymous]

Hi Shiva

my expression is count(tickets)

my dimensions are Ticket_Owners & Tool_Impacted.

when i use the below if(len(Trim(Tool_Impacted))=0,null(),Tool_Impacted) in calculated dimensions i dont find any change in the graph despite suppressing null and zero values.

if I use if(count(Tickets)>0, Tool_Impacted) in the calculated dimension it throws an error. Can tell me whats going wrong in my dimension?

[Anonymous]

Hi Avinash

Attaching the file..Do let me know whats going wrong with my dimesnion