topic Pivot Table Configuration for future 6 months in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Configuration-for-future-6-months/m-p/730426#M1057927 <HTML><HEAD></HEAD><BODY><P>Multiple questions related to same chat:</P><P></P><P>vCurrentMonth = Month(Date(Today()))</P><P></P><P>I have a dashboard with Key metircs and a common Fiscal Calendar selection for all the graphs.</P><P></P><P>I have a Pivot Table that shows <STRONG>Role</STRONG> and <STRONG>FiscalMonthYear</STRONG> as Dimensions.</P><P>There is an expression that shows The numeric value of the difference of FTE Capacity and Demand.</P><P></P><P>I want the chart to ALWAYS show <STRONG>the next 6 months</STRONG>. For example, it should now show the data from Oct-March. Do I edit the time dimension expression? If so, to what?</P><P></P><P><SPAN style="font-size: 10pt;">Lastly, I have a user requirement that there be a User Input an option for the user to have the option to select either all Roles or only those that have less than -1 FTE Variance in any of the next 6 months. No idea where to start with this one.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Any help would be appricated!</SPAN></P></BODY></HTML> Tue, 30 Sep 2014 18:15:28 GMT cbaqir 2014-09-30T18:15:28Z Pivot Table Configuration for future 6 months https://community.qlik.com/t5/QlikView/Pivot-Table-Configuration-for-future-6-months/m-p/730426#M1057927 <HTML><HEAD></HEAD><BODY><P>Multiple questions related to same chat:</P><P></P><P>vCurrentMonth = Month(Date(Today()))</P><P></P><P>I have a dashboard with Key metircs and a common Fiscal Calendar selection for all the graphs.</P><P></P><P>I have a Pivot Table that shows <STRONG>Role</STRONG> and <STRONG>FiscalMonthYear</STRONG> as Dimensions.</P><P>There is an expression that shows The numeric value of the difference of FTE Capacity and Demand.</P><P></P><P>I want the chart to ALWAYS show <STRONG>the next 6 months</STRONG>. For example, it should now show the data from Oct-March. Do I edit the time dimension expression? If so, to what?</P><P></P><P><SPAN style="font-size: 10pt;">Lastly, I have a user requirement that there be a User Input an option for the user to have the option to select either all Roles or only those that have less than -1 FTE Variance in any of the next 6 months. No idea where to start with this one.</SPAN></P><P> </P><P><SPAN style="font-size: 10pt;">Any help would be appricated!</SPAN></P></BODY></HTML> Tue, 30 Sep 2014 18:15:28 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Configuration-for-future-6-months/m-p/730426#M1057927 cbaqir 2014-09-30T18:15:28Z