Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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.