topic No numeric values on the x-axis in QlikView

No numeric values on the x-axis

Mon, 04 Aug 2014 05:43:44 GMT

I want to freeze a point in chart and trying achieve it by using following expression.

=if(AgeFromCurrentV=$(vMinAgeFromCurrentV),AgeFromCurrentV,AgeFromCurrentV+Num(vLife))

vMinAgeFromCurrentV will have the minimum Age Value.

The expression seems give desire results with a hardcode value but it fails with "No numeric values on the x-axis" error when i introduce the vMinAgeFromCurrentV variable.

Re: No numeric values on the x-axis

sujeetsingh — Mon, 04 Aug 2014 05:48:38 GMT

It is obvious.

Why you want to hard code ?

Re: No numeric values on the x-axis

jagan — Mon, 04 Aug 2014 05:52:48 GMT

Hi,

Try like this by removing $ symbol

=if(AgeFromCurrentV=vMinAgeFromCurrentV,AgeFromCurrentV,AgeFromCurrentV+Num(vLife))

=if(AgeFromCurrentV='$(vMinAgeFromCurrentV)',AgeFromCurrentV,AgeFromCurrentV+Num(vLife))

Regards,

Jagan.

Re: No numeric values on the x-axis

Tue, 05 Aug 2014 00:00:21 GMT

Hi Jagan,

Still no luck, with your expression the chart get rendered but the minimum point doen't get freeze it moves while changing vLife ,

Regards

Re: No numeric values on the x-axis

jagan — Tue, 05 Aug 2014 02:46:48 GMT

HI,

Check this value in text object =Num(vLife) and see whether you are getting any value, if you are getting value then it should definitely change. If not can you attach sample file?

Regards,

Jagan.