https://community.qlik.com/t5/App-Development/Month-amp-Week-Filter/m-p/1602323#M44586 <P>Dear User's,</P><P>Good Day to all!!!</P><P>I have a scenario in qlik sense for my project. I have month in one table and it's corresponding week in one table.</P><P>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...</P> Sat, 16 Nov 2024 20:27:05 GMT DhanaRama 2024-11-16T20:27:05Z https://community.qlik.com/t5/App-Development/Month-amp-Week-Filter/m-p/1602323#M44586 <P>Dear User's,</P><P>Good Day to all!!!</P><P>I have a scenario in qlik sense for my project. I have month in one table and it's corresponding week in one table.</P><P>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...</P> Sat, 16 Nov 2024 20:27:05 GMT https://community.qlik.com/t5/App-Development/Month-amp-Week-Filter/m-p/1602323#M44586 DhanaRama 2024-11-16T20:27:05Z https://community.qlik.com/t5/App-Development/Month-amp-Week-Filter/m-p/1602478#M44598 <P>Create a canonical calendar that contains each date and its Month, Year, Week, MM-WW, etc</P><P>Many examples of scripts here</P> Mon, 15 Jul 2019 19:54:46 GMT https://community.qlik.com/t5/App-Development/Month-amp-Week-Filter/m-p/1602478#M44598 dwforest 2019-07-15T19:54:46Z