How to make length of bar chart in sync with Y axis

[anindya_manna]

Hi,

I am using concatenation function in expression to obtain a metric.The problem is metric value is not sync with Y axis

My expression is =NUM(Div((SUM(DCP)/SUM([ANSWD]))/60,1),'00')&':'&Num(Round(((SUM(DCP)/SUM([ANSWD])/60)-Div((SUM(DCP)/SUM([ANSWD]))/60,1))*60,1), '00')

And in the axes tab in the scale portion I did not set any value for static min,max,step.

QlikView Forums & Resources‌@

[sunny_talwar]

May be use a dual function to assign it a numerical value? and then use this technique to set the correct y-axis format:

http://qlikviewcookbook.com/2015/05/currency-and-other-symbols-on-the-y-axis/