Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Load data current month

Where [Date] > MakeDate(2018,7,8) ;

If I understand right the syntax above says if the [Date] field is greater than 7/8/2018 then load the data.  How could I modify it to say if the [Date] field is in the current month then load the data? 

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

where month(date)>=month(today())

This will look at today and find it's month.

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

where month(date)>=month(today())

This will look at today and find it's month.

View solution in original post

Highlighted
Creator
Creator

First Option

Let vCurrentMonth =  Date(Today(),'MMM-YYYY');

Where Date(YourDateField,'MMM-YYYY') = '$(vCurrentMonth)'

Or Second option

Where Date(YourDateField,'MMM-YYYY') = Date(Today(),'MMM-YYYY');