Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
A_Jafery
Partner - Contributor II
Partner - Contributor II

How to filter data based on current year, month and week

Hi guys,

I want to make a filter based on period which are weekly, monthly and annual as show in png.

Date(Date) as [A Date],
WeekDay(Date) as [A Weekday],
Week(Date) as [A Week],
'Week'&Ceil(Day(Date)/7) as [A MonthlyWeek],

1 Solution

Accepted Solutions
Gopi_E
Creator II
Creator II

create inline load for which you created fields then you can use that fields a filter

View solution in original post

2 Replies
Gopi_E
Creator II
Creator II

create inline load for which you created fields then you can use that fields a filter
A_Jafery
Partner - Contributor II
Partner - Contributor II
Author

Thank u.  I already made inline load and make filter thru expression

Period:
LOAD * Inline [
Period
Weekly
Monthly
YTD
];