Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Hide 2nd dimension if null in bar chart?

I'm trying to display # support tickets submitted to our helpdesk and their solution time for a period of time. I have an xls-table with ticket ID, month-year and "column" (a way to categorize tickets i.e. the ticket took 0,5-1h, 1,5-4h etc).

Month-year and column are my dimensions but in the bar chart it is very difficult to see what month a bar belongs to.

Is their a way to remove a bar where a"column" has no tickets?

media_1387543057485.png

2 Replies

Re: Hide 2nd dimension if null in bar chart?

Carl

Try a Calculated dimension for Column, maybe something like:

     If ( YourExpression , Column , null() )

Then when the ones you do not want are set to Null() the Suppress when Value is Null should work.

Best regards,     Bill

Re: Hide 2nd dimension if null in bar chart?

Is their a way to remove a bar where a"column" has no tickets?

No. It will automatically not be shown when there are no tickets for each Finish Month. Otherwise there will always be space reserved for the column. This is because the Column bars can only be ordered in one way across the Finish Month dimension. You see that same ordering in the legend. It is not possible to change this.


talk is cheap, supply exceeds demand
Community Browser