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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.

Labels (1)
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.