topic Populating dimension values based on the selection in QlikView https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891275#M310447 <HTML><HEAD></HEAD><BODY><P>Hello QV Experts,</P><P></P><P>I have a line chart that shows count of Assets (Y axis) per <STRONG>Calendar Year</STRONG> (X axis). In the dashboard there is a list box for field <STRONG>Calendar Year</STRONG>.</P><P>When I select a value in Calendar Year list box (eg: 2013) the line chart gets updated such that it only shows 2013 in x axis. I know this is expected however a line chart with just one dimension value in X axis is not quite meaningful.</P><P></P><P>What I am trying to achieve is this:-</P><P></P><P>When a user selects a year in <STRONG>Calendar Year</STRONG> list box (eg: <EM>2010</EM>) then I want the line chart to show 3 values in X axis: selectedyear-1 , selectedyear and selectedyear +1 (eg: when 2010 is selected in Calendar Year list box, the x axis of line chart should plot for: 2009, 2010 and 2011)</P><P></P><P>I am trying to get this done using calculated dimension with IF statements but no luck so far.</P><P></P><P>Ideas?</P><P></P><P></P><P>Thanks</P><P>Nakul</P></BODY></HTML> Tue, 19 May 2015 20:19:36 GMT Anonymous 2015-05-19T20:19:36Z Populating dimension values based on the selection https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891275#M310447 <HTML><HEAD></HEAD><BODY><P>Hello QV Experts,</P><P></P><P>I have a line chart that shows count of Assets (Y axis) per <STRONG>Calendar Year</STRONG> (X axis). In the dashboard there is a list box for field <STRONG>Calendar Year</STRONG>.</P><P>When I select a value in Calendar Year list box (eg: 2013) the line chart gets updated such that it only shows 2013 in x axis. I know this is expected however a line chart with just one dimension value in X axis is not quite meaningful.</P><P></P><P>What I am trying to achieve is this:-</P><P></P><P>When a user selects a year in <STRONG>Calendar Year</STRONG> list box (eg: <EM>2010</EM>) then I want the line chart to show 3 values in X axis: selectedyear-1 , selectedyear and selectedyear +1 (eg: when 2010 is selected in Calendar Year list box, the x axis of line chart should plot for: 2009, 2010 and 2011)</P><P></P><P>I am trying to get this done using calculated dimension with IF statements but no luck so far.</P><P></P><P>Ideas?</P><P></P><P></P><P>Thanks</P><P>Nakul</P></BODY></HTML> Tue, 19 May 2015 20:19:36 GMT https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891275#M310447 Anonymous 2015-05-19T20:19:36Z Re: Populating dimension values based on the selection https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891276#M310448 <HTML><HEAD></HEAD><BODY><P>Please check if fits your needs</P></BODY></HTML> Tue, 19 May 2015 20:35:36 GMT https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891276#M310448 Clever_Anjos 2015-05-19T20:35:36Z Re: Populating dimension values based on the selection https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891277#M310449 <HTML><HEAD></HEAD><BODY><P>works like a charm! Thank you Anjos.</P></BODY></HTML> Wed, 20 May 2015 14:18:28 GMT https://community.qlik.com/t5/QlikView/Populating-dimension-values-based-on-the-selection/m-p/891277#M310449 Anonymous 2015-05-20T14:18:28Z