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

[prma7799]

It is working with =sum({<Date={"2017.03.01"}>}Value )

Confused

[oscar_ortiz · Accepted solution]

Check this out.  I've modified the script slightly to ensure that your date is using the proper format.  Preceding load on your original inline load statement.

LOAD

  *,

  Date(Date#(Date,'YYYY.MM.DD')) as CheckDate

;

Good luck

Oscar

[prma7799]

Hi Frank,

Without any modification in back end how can we do this?

Thanks

PM

[dberkesacn]

Yep it work with '=' but not with '>'... you have the same result ?

[oscar_ortiz]

The reason it works with "=" and not ">" is because Qlik is treating the field as a text field not numeric value.

[prma7799]

Yes... But if you change you date format in backend you can easily achieve the same.

[dberkesacn]

amazing it was a bug (features?), i just added a preceding load * just this, and worked, after deleted the preceding and reloaded again worked ...

[prma7799]

[dberkesacn]

probably it was because I made the data in excel and copy pasted to the inline wizard ... or just because...

[prma7799]

Yes...

Otherwise you will get your answer early..

Thanks Daniel .