Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sravankumarkaturi

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

6 Replies
simon_minifie
Partner - Creator III
Partner - Creator III

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

sravankumarkaturi
Author

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
Partner - Creator III
Partner - Creator III

Hi Sravan,

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

Capture6.PNG

Best regards,

Simon

sravankumarkaturi
Author

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

thanks- sravan

vvira1316
Specialist II
Specialist II

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...

S1m55r
Contributor III
Contributor III

did you find anything on this ?

or any new feature available in current Qlik sense 2019 version