topic http://community.qlik.com/ in QlikView

http://community.qlik.com/

Sun, 20 Mar 2011 15:35:59 GMT

Hi! I have a doubt. I would like to view a previously loaded table. The instructions I use are the following:

TBCancel_Or_Correct_SPSH:

LOAD COUNT(*)

RESIDENT TBSPSH

WHERE REVDATE BETWEEN

TO DATE ('$(INIFECHA_VAR)','MM/DD/YYYY') AND TO DATE('$(FINFECHA_VAR)','MM/DD/YYYY)

I mark a syntax error

Please support me with the solution

http://community.qlik.com/

deepakk — Sun, 20 Mar 2011 18:10:30 GMT

hi Maya,

the To Date field need to be in [ ] bracket like below.

[TO DATE].

In Qlikview when ever a space is used between fields then it should be put under [ ] brackets.

http://community.qlik.com/

Anonymous — Sun, 20 Mar 2011 18:40:54 GMT

It is Oracle syntax: TO_DATE
(no space but rather underscore)

http://community.qlik.com/

Oleg_Troyansky — Sun, 20 Mar 2011 18:56:46 GMT

To continue Michael's line of thought - you can't use Oracle functions, or any other SQL functions, in QlikVIew LOAD statements, except for those functions that happen to be common between SQL and QlikView.

If you need to convert a string into a date field, you should use QlikView function DATE#(). Also, I don't think that SQL operator BETWEEN is supported in QlikView - replace it with the pair of "<=" and ">="