Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sravankumarkatu
New Contributor III

Custom Y - Axis Scaling

Hi,
I have a requirement for custom scaling on Y axis in Qlik sense. i see Min and Max scaling option in Qliksense but did not help that. can we write any expression or any setting can be made to achieve the below

currently my y axis look like below

Capture.PNG

I need the scale on y axis to look as below

Captur1e.PNG

Thanks - sravan

5 Replies
simon_minifie
Contributor III

Re: Custom Y - Axis Scaling

Hi Sravan,

Yes, it's there.

Appearance -> Y Axis

Change the Range to Custom and then select Min, Max or Min/Max

Capture5.PNG

And you can change the format of the expression data in the Data part.

Hope that helps.

Thanks,

Simon

sravankumarkatu
New Contributor III

Re: Custom Y - Axis Scaling

Thanks for the reply Simon. i tried Min/Max it just sets min value and max value , here i also want to set the scale between them
If i set min to 10 and max to 200k it gives y axis as 10, 200k, 500k, 150k like something
i want to set as 10 100 1000 10000 etc

Thanks- sravan 

simon_minifie
Contributor III

Re: Custom Y - Axis Scaling

Hi Sravan,

You'll need to change that formatting in the Data -> measure -> Number Formatting part of the interface.

Capture6.PNG

Best regards,

Simon

sravankumarkatu
New Contributor III

Re: Custom Y - Axis Scaling

Did not work Simon , Thanks
BTW i wan the scale to be fixed like 1, 10, 100, 1000, 10000 .

thanks- sravan

vvira1316
Valued Contributor II

Re: Custom Y - Axis Scaling

Hi,

In QlikView Log scale is an option (Logarithmic bar chart shows null dimensional value with larger count than other values is showing up...). In QlikSense it is not available but you may try to change your expression using Log function and see if that will help

log10(x )

http://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/ExponentialAndLogari...

Community Browser