Adjust axis dimensions

[#1]

Hi all,

I am trying to make a line chart in Qlik Sense, and i want to adjust the x-axis so that the chart looks better. I have tried to class, but i don't want it to be from "0 to 1" etc. I just want the axis to "jump" by 1 (so that it goes 0,1,2 ..). Does any of you now how to adjust the axis?

Thanks in advance!

Nicolai.

[SreeniJD]

Hi Nicolai,

in your line chart properties go to Axes tab and uncheck "Forced 0" and also set static min as "1" this will works...

HTH

Sreeni

[#3]

Hmm Maybe a stupid question - but where do I find the chart properties i Qlik Sense? I am able to do what you wrote in Qlikview, but what about Qlik Sense?

[JonnyPoole]

you can wrap the class() function with a replace() to replace the   '>= x >'   with ''   ( a blank value).

There are other string functions you can use to just take the lower or upper end of the range

[#5]

I put the following expression: replace(class([Vægt pr pakke],1),'<= x <','') and then my graph looks like this:

But I want the x-axis to like 0 , 1 , 2 etc..

[jonathandienst · Accepted solution]

Class is a dual value, so you can use Num() to extract the value part:

=Num(class([Vægt pr pakke],1))

[JonnyPoole]

great solution. much better than what i was thinking of:

left (  class([Vægt pr pakke],1),  findoneof( class([Vægt pr pakke],1),' ') )

[#8]

That worked perfectly Jonathan, thank you!