Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

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

Re: set analysis with date function

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)

1 Reply

Re: set analysis with date function

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)

Community Browser