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

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

How to convert a string to number?

Hi,

I want to display a text box when the date in another chart must be < 03/04/2013.

For that I wrote a code under the Layout -> Condtional Show of the Text box as below

=GetSelectedCount(Month_Date)<>0 or num(SubField(GetFieldSelections(Month_Date),',',-1))<41366

but the String returned from SubField(GetFieldSelections(Month_Date),',',-1) could not convert to number format.

Anyone please help me...

Thanks in advance

1 Reply
Anonymous
Not applicable
Author

It might be that your Month_Date value needs to be converted to a proper date format first (after parsing it from the field selections) before you can convert it to a number?