This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am working in Qlik Sense and connected to a SQL database. Does anyone know what my where clause would be to bring in the previous 3 years based off of the field "oe-date-ent" (not shown)?
Assuming your field "oe-date-ent" is a date column.
Let Vdatefilter=date(AddYears(today(),-3),'MM/dd/YYYY') // you can use max(oe-date-ent) instead of Today() here, //but you've to load it before the script.
where oe-date-ent >=$(Vdatefilter);
The field oe-date-ent is being loaded in the script that I need to limit on the date so not sure that will work.