Basic Set Analysis

[dberkesacn]

Hi Guys,

pls help me in this simple set analysis, =sum({<Date={">2017.02.01"}>}Value), why this is not working?

Would like to filter the date - global date format in the begging of the script is SET DateFormat='YYYY.MM.DD';.

Thanks,

D

[oscar_ortiz]

You can easily tell that Qlik read the date field in as a text string because the values are left justified.  Plus Daniel already had modified the date format in the script.

[dberkesacn]

indeed.

[prma7799]

Yes oscar.ortiz‌ you are right ...

Thanks ...

[Frank_Hartmann]

without backend modification this expression should work:

sum({<Date={"=Date>date#('2017.02.01','YYYY.MM.DD')"}>} Value)