Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

No numeric values on the x-axis

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.

4 Replies
sujeetsingh
Master III
Master III

It is obvious.

Why you want to hard code ?

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this by removing $ symbol

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


or


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


Regards,

Jagan.



Not applicable
Author

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

K

jagan
Partner - Champion III
Partner - Champion III

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.