Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Date, Week, Month, Quarter and Year data filtration.

Hi Team,

Need assistance for a requirement which is like below:

I want Day, Week, Month, Quarter, Year selection option in my chart.

If anyone select as date then the date calendar should populate and the user should be able to select one or more dates in the calendar, accordingly data should filter out and shown to user.

similarly on month selection, 12 months should populate and User can be able to select the desired month to view the data. Similar for Week, Quarter and Year.

Basically this requirement need to see the reports in daily, weekly, monthly, quarterly and yearly basis.

Please let me know how it could be possible to achieve or suggest any alternate way if we can do. Also suggest if this can be done by using some extensions.

Any suggestions and helps would be highly appreciated.

Thanks and Regards,


2 Replies

Re: Date, Week, Month, Quarter and Year data filtration.

Is this requirement for qlik sense or qlik view?


Re: Date, Week, Month, Quarter and Year data filtration.


you will have to create a master calender.

Master Calendar Generation Script



    Date(InvoiceDate) AS InvoiceDate,

    Year(InvoiceDate) AS Year,

    'Q' & Ceil(Month(InvoiceDate) / 3) AS Quarter,   

    Month(InvoiceDate) As Month,

    Day(InvoiceDate) As Day,

    Week(InvoiceDate) As Week;