Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ateafilar
New Contributor III

Integer i continous x-axis

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

Tags (3)
1 Solution

Accepted Solutions

Re: Integer i continous x-axis

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.


talk is cheap, supply exceeds demand
7 Replies
ateafilar
New Contributor III

Re: Integer i continous x-axis

qv11.PNG

And here is the print screen...

narender123
Valued Contributor

Re: Integer i continous x-axis

pls show your data..

ateafilar
New Contributor III

Re: Integer i continous x-axis

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

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.


talk is cheap, supply exceeds demand
ateafilar
New Contributor III

Re: Integer i continous x-axis

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

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.


talk is cheap, supply exceeds demand
ateafilar
New Contributor III

Re: Integer i continous x-axis

OK, thanks for your answers.


Case closed.

Community Browser