topic Integer i continous x-axis in QlikView

Integer i continous x-axis

Anonymous — Mon, 25 Mar 2013 08:28:21 GMT

Hello!

I have a problem with a continous x-axis in a bar chart... Though the x-axis presents weeks, I want to show weeks even though they don't have a value with my selections.

I get the result I want below, BUT once again, as the x-axis presents weeks, I want only valid integer weeks. I have forced the scale to an integer value in the "Number" tab in the chart properties, without a successful result.

I am using QV 11.

Thanks in advance.

/ Filip

Re: Integer i continous x-axis

Anonymous — Mon, 25 Mar 2013 08:29:39 GMT

And here is the print screen...

Re: Integer i continous x-axis

narender123 — Mon, 25 Mar 2013 09:36:39 GMT

pls show your data..

Re: Integer i continous x-axis

Anonymous — Mon, 25 Mar 2013 12:16:38 GMT

No offense, but why would I need that? As you can see in the chart, there are no values for any other week than week 6 and week 8.

Re: Integer i continous x-axis

Gysbert_Wassenaar — Mon, 25 Mar 2013 12:31:13 GMT

On the Axes tab set Static Step to 1 for the dimension axis.

Or add a table with all weeks

Weeks:

load recno() as Week

autogenerate(52);

And enable the options Suppress When Value Is Null for the Week dimension and disable the options Suppress Zero-Values and Suppress Missing on the Presentation tab.

Re: Integer i continous x-axis

Anonymous — Mon, 25 Mar 2013 12:33:51 GMT

Thanks, that solves the problem... what is your suggestion later in the year, when we have a lot of weeks..? A x-axis scrollbar?

Re: Integer i continous x-axis

Gysbert_Wassenaar — Mon, 25 Mar 2013 12:37:57 GMT

Yeah, a scrollbar or select a number of weeks in a listbox. Or a quarter. Whatever best fits the situation, i.e. best answers the question you created the chart to answer.

Re: Integer i continous x-axis

Anonymous — Mon, 25 Mar 2013 12:39:00 GMT

OK, thanks for your answers.

Case closed.