An Invalid Character was found in text context

[jaspal_icon]

Hello All,

I am slecting some Date range on press of button. it working Fine on local Desktop, but after deployment on server I am getting the "An Invalid Character was found in text context" Eror.

Please tell whats the problem behind it, the document is larger in Around 200MB, so I cant share the document.

FiledName "Date  "

='>=' & Date(vDateMin, 'DD/MM/YYYY 00:00:00') & '<=' & Date(vDateMax, 'DD/MM/YYYY 23:59:59')

Any Help in this regard will be helpful, if any one encounter the same problem.

Environment:

QlikView Dsktop: 11.2

QlikView Server 11.

Thanks

Regards

[Sokkorn]

Hi,

Look like format issue. Let try

='>=' & Date(vDateMin, 'DD/MM/YYYY') & '00:00:00' & '<=' & Date(vDateMax, 'DD/MM/YYYY') & '23:59:59'

Regards,

Sokkorn

[jaspal_icon]

Thanks Sokkorn for Quick Reply,

But your giving solution is not working at all.

The Action on Button is "Select in Field"

Thanks

[jaspal_icon]

One More point:

On Access point While accessing the page I can see in left bottom Javascript Warnining.

QvAjax.js -- Invalid Argument

[jaspal_icon]

Hi All, I checked that same is working fine in Chrome Browser, and with Plugin, only issue seems to be with IE-8 with Ajax, or Full Browser. Please let me know if anyone know fix for this.

Thanks

Regards

[Sokkorn]

Hi,

Just try this one more and let me know

='>=' & Date(vDateMin, 'DD/MM/YYYY hh:mm:ss') & '<=' & Date(vDateMax, 'DD/MM/YYYY hh:mm:ss')

Regards,

Sokkorn

[jaspal_icon]

Hi Sokkorn,

I think the formatting is not the problem here, My formatting is working fine, even your last given also. This problem is related to IE-8 and Ajax, i got one community link. Becuase things are workign fine when I tried to open it in Chrome browser. It seems to be bug with QlikView and there must be a patch.

if Anyone read this then please help me providing the patch or any set of instructions to fix this.

Thanks

Regards

[Anonymous]

We had this issue occur recently. The document was developed in v11.02 SR3. We only received the error in IE9. Chrome, IE10, and IE11 just quietly failed to load some of the controls.

Short Answer:

In the load script - purgechar(purgechar(purgechar(<FIELD-WITH-BAD-DATA>,chr(1)),chr(10)),chr(13))

Long Answer:

We upgraded to 11.02 SR5. This didn't help. It didn't hurt either, though. So, we kept it.

We narrowed the problem down to a single control by putting every control in a container. This permits all working controls to load and only the control with an issue fails to load. We then removed a single field at a time until the control loaded. We were working with a straight table, but the same concept should work for other controls. We then removed the offending characters mentioned above in the short answer.

It is likely that only one or two of the characters above are the culprit, but I'm tired of messing with it and we don't need any of them so they are purged!

Happy Qliking