topic Display all dimension value in a line chart in QlikView

Display all dimension value in a line chart

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a line chart. When i select january to july, the dimension date shows only until 24/04. For show until 25/07, i have to increase the width or enable X axis scrollbar. But i want to keep the same size and disable X axis scrollbar.

I cant' remember how to fix this.

Thanks

Re: Display all dimension value in a line chart

felipedl — Thu, 26 Jul 2018 18:14:17 GMT

Hi Jean,

Just made a sample test data here, and without any filters it shows me all days on my datamodel (just made a model from April to July and the expression is just sum(value) for dummy data), so i'm assuming that either your data is being filtered to only show those days, or you're limiting that on the chart elsewhere (through set analysis on the expression or something like that).

Other possible hole is that your data doesn't have all days as rows, so when you apply the expression, it creates "gaps" for your days, they're not continuous on your chart.

Try creating a bar chart from scratch and use the same expression and see the result.

My example gave me the following:

That's one ugly chart on my opinion, since plotting all the days will get some really bad interpretation, I'd advise using the x-scroll bar for 30+ results.

I wouldn't be able to tell which point of the chart is for which day, but that's me .

Hope it helps.

Re: Display all dimension value in a line chart

MarcoWedel — Thu, 26 Jul 2018 19:16:09 GMT

Hi,

two options to show all values without scroll bar or increasing the chart width would be to either

- switch to continuous dimension axis (your dates have to have a numeric value to be able to check this option):

- check the "Show All Bars" option (you have to temporarily switch to bar chart type to activate this option. After applying it you can switch back to line chart.)

hope this helps

regards

Marco

Re: Display all dimension value in a line chart

sergio0592 — Fri, 27 Jul 2018 07:04:50 GMT

Thanks Felip and Marco for your answers. But when i want check "Show all bars", it's disable.

I have 4 expressions, Year N, Year N-1, Year N-2, Year N-3, Year N-4. And if i check, Axis/continuous, i have the following message : "No numeric values on X-axis".

Re: Display all dimension value in a line chart

MarcoWedel — Mon, 13 Aug 2018 19:57:59 GMT

please post a sample application to demonstrate