Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (2)
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