topic Re: How do I show only a few values in a line graph? in QlikView

How do I show only a few values in a line graph?

Thu, 24 Dec 2015 15:24:35 GMT

Hi all!

I have the next graph:

I would like to show the labels but the graph would be this:

I would like to show only the most representative values... Is there solution for this?... Could someone to help me?...

Thanks in advance....

Re: How do I show only a few values in a line graph?

Peter_Cammaert — Thu, 24 Dec 2015 15:50:45 GMT

To improve the spacing between data points, enable an X-axis scroll bar.

What are the most representative values? If you mean the highest values, have a look at Dimension Limits where you can easily restrict the values shown to for instance the top 10.

Peter

Re: How do I show only a few values in a line graph?

Anonymous — Thu, 24 Dec 2015 15:55:47 GMT

Maybe use a horizontal bar chart, then you'll be able to show all values and they won't overlap each other.

Re: How do I show only a few values in a line graph?

Thu, 24 Dec 2015 16:05:18 GMT

I don't know how to add a scroll bar...

I tried to take Dimension Limits but in this case I working with an Expression not with Dimension...

Re: How do I show only a few values in a line graph?

Thu, 24 Dec 2015 16:13:11 GMT

Bill I think is a good idea to use a horizontal bar, but we could have 53 weeks and in this case would be impractical to use a horizontal bar...

Re: How do I show only a few values in a line graph?

Peter_Cammaert — Thu, 24 Dec 2015 17:07:19 GMT

In your line chart, goto Properties->Presentation and in the Chart Scrolling-group (right side in the middle), check Enable X-Axis Scrollbar. Select a number of Dimension values above which the scroll bar should be displayed.

Peter

Re: How do I show only a few values in a line graph?

Gysbert_Wassenaar — Fri, 25 Dec 2015 07:29:34 GMT

Perhaps you can use the Show Value option and use the Rank function to show the Top X values:

Re: How do I show only a few values in a line graph?

MarcoWedel — Sun, 27 Dec 2015 16:11:47 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: How do I show only a few values in a line graph?

Mon, 28 Dec 2015 12:55:42 GMT

Thank you very much Gysbert.

So is it possible to show for example the 10 highest values and the 10 lowest values?

Re: How do I show only a few values in a line graph?

Mon, 28 Dec 2015 13:14:32 GMT

It is possible to display the values every 3 month?... This would be better because if you have 2 high values next to each other then also not be displayed correctly..

Re: How do I show only a few values in a line graph?

Gysbert_Wassenaar — Mon, 28 Dec 2015 16:42:56 GMT

Yes, with something that checks the row number: if(Mod(RowNo(),3)=0,1,0)

Re: How do I show only a few values in a line graph?

Gysbert_Wassenaar — Mon, 28 Dec 2015 16:44:16 GMT

Yes. =if(rank(sum(Sales))<=10 or rank(-sum(Sales))<=10,1,0)