topic How show all values in chart in QlikView

How show all values in chart

Wed, 04 Nov 2009 22:36:02 GMT

Hello, I need view all values in a Chart, but i can't 😞 I have a table with all days from 1/1/2009 to 12/31/2009 and the chart show me only to May, then I have to enlarge this to see more values

How show all values in chart

Oleg_Troyansky — Wed, 04 Nov 2009 22:50:36 GMT

I'm guessing that you have too many data points, and they can't all fit on the chart... A few possible solutions:

1. Either determine a fixed number of data points to show on the screen, and allow "Horizontal Scroll-bar" (those settings are on the "Presentation" tab)

2. Or, if your dates are proper Date fields, you can declare your axis as "continuous" QlikView will then scale the chart appropriately, but only one date in a month, or in a quarter (depending on the available space) will be shown. I'm assuming that you are referring to a line chart... This setting in on the Axis tab.

cheers,

How show all values in chart

Wed, 04 Nov 2009 23:07:05 GMT

Thaks Oleg I have already tried this options, I'm looking for other option maybe don't show all points in the chart, but see the first point and the last one and some values between. If I choose "continuos" then the chart shows me falses values and that does not help

How show all values in chart

johnw — Thu, 05 Nov 2009 02:04:01 GMT

If you don't want to scroll, and it's OK to not see every day's data, you could average the daily value by week or by month. So use Week or Month as your dimension, and as an example, avg(aggr(sum(Sales),Date)) as your expression. The reason to not just use sum(Sales)/7 for weeks is that you might just select a month, for instance, and then your first and last week would likely have an incorrectly low average due to not having enough days of data.

How show all values in chart

Thu, 26 Nov 2009 18:22:05 GMT

Hi Oleg,

For my problem the idea to use continuous is great. I have an additional question. Do you know how I can force the line to show the zero values, also when there is no order data available? See the screenshot below at 14 november.

How show all values in chart

prieper — Fri, 27 Nov 2009 04:27:23 GMT

Think that you have to builta consecutive calendar with all day, join with the data and insert the expression to show "0", if the value is NULL.

Peter

How show all values in chart

Mon, 14 Dec 2009 15:47:45 GMT

Oke. I gonna try that.

How show all values in chart

Tue, 15 Dec 2009 16:23:32 GMT

I have solved this by using a join:

//add the missing calendar values
RIGHT JOIN (Orders)
LOAD %DateKey
RESIDENT Calendar;

Re: How show all values in chart

Fri, 04 May 2012 10:10:58 GMT

The join trick still only works if you don't select a dimension value. See example. By left joining all weeks with the fact table QlikView still doesn't know the dimension keys so this doesn't really solve anything. Another solution could be to do something when building the fact table. make a 0 revenue record for all dimension keys.

One could argue if a Fact table design should be influenced by the presentation layer...

Re: How show all values in chart

qlikviewforum — Wed, 11 Feb 2015 08:15:47 GMT

Hi Oleg,

When I use "Continuous" option in axes, I am getting the date in numbers(in the chart) though the Date field which is in Dimension is in proper date format. Could you please help on this?

Re: How show all values in chart

qlikviewforum — Wed, 11 Feb 2015 08:51:15 GMT

I have achieved it by changing the date format in the Number tab. Thanks all

Re: How show all values in chart

Anonymous — Fri, 18 Dec 2015 12:54:35 GMT

I had the same problem. I resolved it checking "Show All Bars" at the presentation bar.