Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivot table for the actual Month - regardless what the user selects.
The first dimension should only show the calendar weeks of the actual Month.
My Table MainCalendar looks like this:
MainDate MainDateMonth MainDateCalendarWeek MainDateYear
04.07.2019 7 27 2019
05.07.2019 7 27 2019
...
So how to write the Dynamic Dimension, so it shows only the calendar weeks from the actual month which is "today" and ignores users selection.
Please see attached Image, what I expect for today (5th july 2019)
PS: Ive got two variables (vGetActualMonthNum) and (vGetActualYear) which returns the current month and year
Believe you are going to want to use Set Analysis for this one:
Help:
Design Blog:
https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Best I have, hopefully it may help you move things forward.
Regards,
Brett