Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Adjust axis dimensions

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Adjust axis dimensions

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
7 Replies
jaaldurgam
Valued Contributor

Re: Adjust axis dimensions

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

Not applicable

Re: Adjust axis dimensions

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?

Employee
Employee

Re: Adjust axis dimensions

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

Not applicable

Re: Adjust axis dimensions

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

Qlik - Density function(1).PNG

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

MVP
MVP

Re: Adjust axis dimensions

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Employee
Employee

Re: Adjust axis dimensions

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

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

Not applicable

Re: Adjust axis dimensions

That worked perfectly Jonathan, thank you!

Community Browser