Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Create a canonical calendar that contains each date and its Month, Year, Week, MM-WW, etc
Many examples of scripts here