Where Condition

[danny4202001]

hello friends,

How to change the below where condition if we need data starting last week to future infinite everything available in the source 

Weekstartdate = WeekStart(Now(),-1,0)

Thanks,

D

[QFabian · Accepted solution]

Hi @danny4202001 maybe this :

Where

datefield  >= today()-7

Weekstartdate = WeekStart(Now(),-1,0)

[danny4202001 · Accepted solution]

Hello Fabian, 

Thank you for the reply, What if you need data from YTD?

Thanks

[QFabian]

datefield  >= yearstart(today())

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...