Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
DhanaRama
Contributor
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
dwforest
Specialist II
Specialist II

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

Many examples of scripts here