https://community.qlik.com/t5/QlikView/Dimensions-Only-show-specific-values-in-Pivot/m-p/1607732#M737148 <P>Believe you are going to want to use Set Analysis for this one:</P> <P>Help:&nbsp;</P> <P><A href="http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_blank">http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm</A></P> <P>Design Blog:&nbsp;</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P> <P>Best I have, hopefully it may help you move things forward.</P> <P>Regards,<BR />Brett</P> Tue, 30 Jul 2019 20:14:25 GMT Brett_Bleess 2019-07-30T20:14:25Z https://community.qlik.com/t5/QlikView/Dimensions-Only-show-specific-values-in-Pivot/m-p/1599273#M737147 <P>Hi,</P><P>I have a Pivot table for the actual Month - regardless what the user selects.</P><P>The first dimension should only show the calendar weeks of the actual Month.</P><P>My Table MainCalendar looks like this:</P><P><STRONG>MainDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MainDateMonth&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MainDateCalendarWeek&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MainDateYear</STRONG></P><P><STRONG>04.07.2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 27&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019</STRONG></P><P><STRONG>05.07.2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 27&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2019</STRONG></P><P><STRONG>...</STRONG></P><P>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.</P><P>Please see attached Image, what I expect for today (5th july 2019)</P><P>PS: Ive got two variables (vGetActualMonthNum) and (vGetActualYear) which returns the current month and year</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Dimensions-Only-show-specific-values-in-Pivot/m-p/1599273#M737147 HermGerm 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Dimensions-Only-show-specific-values-in-Pivot/m-p/1607732#M737148 <P>Believe you are going to want to use Set Analysis for this one:</P> <P>Help:&nbsp;</P> <P><A href="http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_blank">http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm</A></P> <P>Design Blog:&nbsp;</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P> <P>Best I have, hopefully it may help you move things forward.</P> <P>Regards,<BR />Brett</P> Tue, 30 Jul 2019 20:14:25 GMT https://community.qlik.com/t5/QlikView/Dimensions-Only-show-specific-values-in-Pivot/m-p/1607732#M737148 Brett_Bleess 2019-07-30T20:14:25Z