topic Re: How to see all values in a chart? in QlikView

How to see all values in a chart?

Fri, 22 Feb 2013 12:44:47 GMT

Hi, All

I have a chart wit about 1000 values (also see attachment)
Dimension of the chart is not numeric and most of the chart line lies beyond chart, when i resize i can see more of the line.

the chart before resize

chart after resize (more of the chart line appears)

How to make the whole chart line lie within the chart?

i've tried to make calculated dimension, but i cannot make it (there is a field by which we may filter values shown in the graph)

Re: How to see all values in a chart?

Sun, 24 Feb 2013 18:10:34 GMT

Is it possible at all to see all values?

i chehked and uncheked all checkboxes in many combinations, but achieved nothing

help me with some idea

thanks

Re: How to see all values in a chart?

phaneendra_kunc — Sun, 24 Feb 2013 18:37:50 GMT

Here is the Trick....

Bar Chart has option called "Show Allbars" under Presentation..this will eanbles to see all data points even though if you have lot of em...

So convert your line chart to BAR and then select that option and change your chart to Line again...

Only this here is that "Dimension labels doesnt make sence here..since there is no much space to show all of them in the x-axis. so some of them wont show up...But that's ok...

Some thing like if you have data 1 to 10000.

axis will show 1 5 10 15...etc..

Phani

Re: How to see all values in a chart?

Sun, 24 Feb 2013 18:49:10 GMT

It is a problem with so many (1,000) dimension values like this.

You can use a horizontal scroll (Presentation tab, Chart scrolling, X-axis scroll bar).

You can reduce font size for your Dimension, or in your case, just get ride of it completely (un-check Show Legend on Dimension tab).

Phaneendra Kunche - thanks for tip. I didn't consider setting as a bar, then flipping back to line. Good to know.

Re: How to see all values in a chart?

Sun, 24 Feb 2013 19:14:22 GMT

Phani, Thank you for your answer, it solves my problem

Donald, Thank you for helpful answer, it can be used in future