topic How to display values on X axis without anything missing in QlikView

How to display values on X axis without anything missing

Thu, 14 Nov 2013 13:09:01 GMT

Hi,

Please refer to attached Chart 1. I was not able to show complete name on the axis. How can i show complete values.

I got some chart from online(Helpdesk management), how can i show similarly like that. I attached Chart 2 which i found online.

Thanks,

Chris

Re: How to display values on X axis without anything missing

mbm — Fri, 15 Nov 2013 15:48:50 GMT

Sekhar,

Without seeing the application, it looks like you wither have null values in your name dimension, or you're using a calculated dimension that's excluding some of the names. That would be why you're seeing the - as a name value. Can you post a sample application for us to take a look at?

Re: How to display values on X axis without anything missing

Clever_Anjos — Fri, 15 Nov 2013 16:19:16 GMT

If you want to show values use an expression like this

dual(

sum(Expression1) & ' ' & sum(Expression2), // Display

sum(Expression1) // this will give bar length

)

Re: How to display values on X axis without anything missing

Fri, 15 Nov 2013 16:29:15 GMT

Sekhar Gandham wrote:

How can i show complete values.

Highlight the bar chart and hold down Ctrl+Shift. The bar chart area should now be outlined in red. You can now make the bar chart area smaller by dragging with your mouse.

See Dropbox - 2013-11-15 16h26_24.mp4

Re: How to display values on X axis without anything missing

antoinelaviron — Fri, 15 Nov 2013 16:41:11 GMT

Hi,

If you need to adjust the label area for the axis you need to do the following:

1)Select you chart

2)Press the following combination :CTRL + SHIFT

3) You will see 3 red rectangles. While having CTRL & SHIFT pressed, adjust their borders in order to hae enough space for your labels

Hope this helps

Best regards,

Antoine

Re: How to display values on X axis without anything missing

Fri, 15 Nov 2013 16:45:25 GMT

Good one even I had the same problem and I sort it now because of your answer.

Thanks.

Re: How to display values on X axis without anything missing

Fri, 15 Nov 2013 19:44:28 GMT

Re: How to display values on X axis without anything missing

Fri, 15 Nov 2013 19:47:37 GMT

How do we resize the labels to the bar.?

The full label names is not displayed in the bar ?

Re: How to display values on X axis without anything missing

Mon, 25 Nov 2013 15:18:57 GMT

Awsome.. Thanks a lot Antoine.