topic How to get all values shown on x-axis in QlikView

How to get all values shown on x-axis

Tue, 29 Apr 2014 13:25:00 GMT

Hello,

Lets say i have this data:

DayNumber	Flag
2	1
8	1
9	1

If i make a barchart with a Count on flag, i will get 1 on each DayNumber.

But what if i want to show 1,2,3,4,5,6,7,8,9 on the x-asis even though 1,3,4,5,6,7 doesnt have any flag?

Ive tried to make an integertable and leftjoined it but that doesnt work

Re: How to get all values shown on x-axis

maxgro — Tue, 29 Apr 2014 13:40:37 GMT

i think same answer as

Show full range when making selection

Re: How to get all values shown on x-axis

MK_QSL — Tue, 29 Apr 2014 13:44:18 GMT

Have you got other day fields in your data model?

if yes use as below

Do as Below

Dimension Tab

Untick Suppress When Value is NULL

Tick Show All Values

Expression Tab

Tick Value on Data Points

Presentation Tab

Untick Suppress Zero Value

Tick Zero On Bars

Hope this helps..

Re: How to get all values shown on x-axis

tresB — Tue, 29 Apr 2014 13:46:39 GMT

And, if you don't have all the DayNumbers even in the master table, you can produce them in the front-end using continuous dimension axis(Axes tab) like attached sample.

Re: How to get all values shown on x-axis

Tue, 29 Apr 2014 13:59:24 GMT

What do i do if i want to link it to an integer table?

I can do like this:

IntTable:

RowNo() as ID

RowNo() as Int autogenerate(100);

left join (IntTable)

DayNumber:

DayNumber as Int,

Flag

But the problem is here, if i use Int as an dimension (i would get 100 values)

Is there any way to make the autogenerate generic so i can use the maxvalue in DayNumber (theni would only autogenerate up to the max value)

Re: How to get all values shown on x-axis

tresB — Tue, 29 Apr 2014 14:06:05 GMT

Yes, like:

b:
load * inline [
field1,field2
2,1
8,1
9,1
];

LOAD Max(field1) as Max Resident b;
Let vMax=Num(Peek('Max'));

Load
RowNo() as field1
AutoGenerate $(vMax);