Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to convert a string to number?


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
Honored Contributor

Re: How to convert a string to number?

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?

Community Browser