Qlik Community

Qlik Sense App Development

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

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Month & Week Filter

Dear User's,

Good Day to all!!!

I have a scenario in qlik sense for my project. I have month in one table and it's corresponding week in one table.

As of now i am showing month year, month in my filter. Now, I want to add week as well with the dataset and show them as "mm-ww" in my filter. I know that can be accomplished with it's date column. But the problem is they are calculating this with front end application as week and month only. In my database i have week and column alone in my table and both are in separate table's. Is this achievable as "MM-WW". Please guide me...

Labels (3)
1 Reply
Valued Contributor II

Re: Month & Week Filter

Create a canonical calendar that contains each date and its Month, Year, Week, MM-WW, etc

Many examples of scripts here