Discussion Board for collaboration on QlikView Scripting.
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
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?