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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Invalid expression Error for different statments..

Hi,

I am getting Invalid expression for some times and sometimes not ;

please advise me , did i miss anything in error table ?

//Following throws    NO ERROR

TEMP1:

LOAD * INLINE [

    Country, Value, SalesDate

    USA, 12, 2013-01-04

    USA, 14.5, 2013-02-07

    USA, 6.6, 2013-03-03

    USA, 4.5, 2013-04-11

    USA, 7.8, 2013-05-19

    USA, 9.4, 2013-06-22

    UK, 11.3, 2013-01-31

    UK, 10.1, 2013-02-01

    UK, 3.2, 2013-03-21

    UK, 5.6, 2013-04-15

    UK, 3.9, 2013-05-12

    UK, 6.9, 2013-06-06

];

MINMAX:

LOAD

month(date#(SalesDate,'YYYY-MM-DD')) as monthdate

Resident TEMP1;

DROP TABLE TEMP1;

/////FOLLOWING THROWS INVALID EXPRESSIONS

TEMP1:

LOAD * INLINE [

    Country, Value, SalesDate

    USA, 12, 2013-01-04

    USA, 14.5, 2013-02-07

    USA, 6.6, 2013-03-03

    USA, 4.5, 2013-04-11

    USA, 7.8, 2013-05-19

    USA, 9.4, 2013-06-22

    UK, 11.3, 2013-01-31

    UK, 10.1, 2013-02-01

    UK, 3.2, 2013-03-21

    UK, 5.6, 2013-04-15

    UK, 3.9, 2013-05-12

    UK, 6.9, 2013-06-06

];

MINMAX:

LOAD

month(date#(SalesDate,'YYYY-MM-DD')) as monthdate,

Max(date#(SalesDate,'YYYY-MM-DD')) as maxdate

Resident TEMP1;

DROP TABLE TEMP1 ;

10 Replies
sunny_talwar

Yes, it does seem to work

TEMP1:

LOAD * INLINE [

    Country, Value, SalesDate

    USA, 12, 2013-01-04

    USA, 14.5, 2013-02-07

    USA, 6.6, 2013-03-03

    USA, 4.5, 2013-04-11

    USA, 7.8, 2013-05-19

    USA, 9.4, 2013-06-22

    UK, 11.3, 2013-01-31

    UK, 10.1, 2013-02-01

    UK, 3.2, 2013-03-21

    UK, 5.6, 2013-04-15

    UK, 3.9, 2013-05-12

    UK, 6.9, 2013-06-06

];

MINMAX:

LOAD Month(Date#(SalesDate,'YYYY-MM-DD')) as monthdate,

  Date(Max(Date#(SalesDate,'YYYY-MM-DD'))) as maxdate

Resident TEMP1

Group By Month(Date#(SalesDate,'YYYY-MM-DD'));

DROP Table TEMP1;