Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

set analysis with date function

I have

SUM({<DATE_PRODUCTION={'DATE(date#(DATE_PROD),'DDMMYYYY') <= $(=DATE_EXTRA)'}>}PRODUCTION)



in this part the experssion with red line (error)

1 Solution

Accepted Solutions
Highlighted

Replace the outer single quotes with double quotes and also add an equal sign

Sum({<DATE_PRODUCTION={"=Date(Date#(DATE_PROD), 'DDMMYYYY') <= $(=DATE_EXTRA)"}>}PRODUCTION)

View solution in original post

1 Reply
Highlighted

Replace the outer single quotes with double quotes and also add an equal sign

Sum({<DATE_PRODUCTION={"=Date(Date#(DATE_PROD), 'DDMMYYYY') <= $(=DATE_EXTRA)"}>}PRODUCTION)

View solution in original post