topic Re: Chart dimension: Not showing all values. Incorrect scale? in QlikView

Chart dimension: Not showing all values. Incorrect scale?

Wed, 25 Nov 2020 16:16:04 GMT

I have a line chart with one dimension and three expressions. Dimension is a date field. The problem is that not all data is being shown in the line chart (not all dates are shown for dimension). Initially I thought that I had a problem loading data so I checked this and it was not the problem. Also in chart properties, within dimensions tab, I tried to check "show all values" option, but this does not affect, it does the same. Also I has tried to uncheck "Supress zero values" from Presentation tab but it does not work.

So after checking many things, I had an idea: In design time, I did line chart wider and I saw that more data was being shown so I think there is a problem with the dimension scale. I suppose QlikView by default uses a scale which only show first X values.

So my question is, Is it possible to make always all values visible in the line chart?

Re: Chart dimension: Not showing all values. Incorrect scale?

sunny_talwar — Mon, 01 Aug 2016 19:53:44 GMT

I guess if it doesn't fit the screen then you will always have trouble. May be you can try to show Vertical label for Primary Dimensions Labels on the Dimension Axis tab.

Best,

Sunny

Re: Chart dimension: Not showing all values. Incorrect scale?

swuehl — Mon, 01 Aug 2016 20:03:21 GMT

You can enable 'Continuous' axis on axes tab.

Re: Chart dimension: Not showing all values. Incorrect scale?

Tue, 02 Aug 2016 00:38:35 GMT

Enabling 'Continuous' shows dates as numbers for dimension....

Re: Chart dimension: Not showing all values. Incorrect scale?

Tue, 02 Aug 2016 01:22:23 GMT

Doing this seems to not work.

Re: Chart dimension: Not showing all values. Incorrect scale?

sunny_talwar — Tue, 02 Aug 2016 01:26:46 GMT

Have you tried changing the format of Continuous X-axis field to Date?

Re: Chart dimension: Not showing all values. Incorrect scale?

sunny_talwar — Tue, 02 Aug 2016 01:29:21 GMT

Can you look at my other response below?

Re: Chart dimension: Not showing all values. Incorrect scale?

Tue, 02 Aug 2016 08:05:05 GMT

Hi Sunny,

The line chart I have contains 1 dimension and three expressions. Dimension is a date range and the expressions are money type that have one value or another depending on the date so date dimensions is not shown in Numbers tabs as it is not an expression, only expressions appear there. So I cannot change dimension to Date type. I am not sure if I am understanding at all what you are trying to explain me.

Re: Chart dimension: Not showing all values. Incorrect scale?

swuehl — Tue, 02 Aug 2016 08:18:37 GMT

The suggested approach was:

a) Change to 'Continuous' axis on Axes tab

b) Change format of Continuous axis to Date on Number tab (you should see an entry for continuous axis after a) )

If this does not work for you, could you then upload a small sample QVW that demonstrate your issue?

Re: Chart dimension: Not showing all values. Incorrect scale?

uacg0009 — Mon, 08 Aug 2016 11:28:03 GMT

Hi Stefan,

I saw your method, it works for me and thanks so much!

But I met another problem, if I use Continuous and change it to Date, the dimension label will be wrong.

It will show the Continuous X-axis label, not show my dimension label.

is there any method to solve that?

Thanks.

Aiolos Zhao

Re: Chart dimension: Not showing all values. Incorrect scale?

swuehl — Mon, 08 Aug 2016 11:40:43 GMT

Not quite sure what you are talking about. If I change the dimension label on dimension tab, it will be reflected on chart, regardless if it's a continuous axis or not.

Could you be more specific or could you post a screenshot?

Re: Chart dimension: Not showing all values. Incorrect scale?

uacg0009 — Tue, 09 Aug 2016 02:29:28 GMT

Hi Stefan,

Sorry for that maybe I'm not clarified what I want to ask.

As you can see that normally my dimension is a cyclic group that shows MonthName.

And When I use the Continuous X-axis :

The dimension change like this above, just this problem. can I also show my cyclic dimension value and also see all values for dimension in line chart?

Hope it's clear to you, thanks.

Aiolos Zhao

Re: Chart dimension: Not showing all values. Incorrect scale?

hfkchristian — Thu, 20 Jun 2019 09:27:39 GMT

Did you find a soloution to this? I have the same problem. QlikView will not fit all values inside the chart, unless I tick the continuous box. But if I tick continuous , the labels are destroyed.