Solved: Re: Basic Set Analysis - Qlik Community

dberkesacn · ‎2017-06-22

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 · ‎2017-06-22

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

View solution in original post

prma7799 · ‎2017-06-22

Please check date format

=sum({<Date={">01.03.2017"}>}Sales_Total )

This is working in my app.

MK_QSL · ‎2017-06-22

What is the format of your Date field?

Report Inappropriate Content · ‎2017-06-22

try to use date format of your "Date" data field in set comparision.

Frank_Hartmann · ‎2017-06-22

what format has your "Date" field?

maybe:

sum({<Date={'>2017.02.01'}>}Value)

hope this helps

dberkesacn · ‎2017-06-22

it come from the initial global variable SET DateFormat='YYYY.MM.DD'; and the source data has also this structure.

prma7799 · ‎2017-06-22

Could you please share some sample app

sasikanth · ‎2017-06-22

HI

Try this

=SUM({<Date={"> $(=num(Dat#( '2017.02.01','YYYY.02.01'))) "}>}Value)

dberkesacn · ‎2017-06-22

Yes.

Frank_Hartmann · ‎2017-06-22

see attached file

hope this helps