topic Dynamic dimension in QlikView https://community.qlik.com/t5/QlikView/Dynamic-dimension/m-p/1048478#M352297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table as follows (lets call it 'Contact' table):</P><P><IMG alt="datasource.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113533_datasource.jpg" style="height: auto;" /></P><P></P><P>And a chart that displays that Contact table:</P><P><IMG alt="contactflux.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/113544_contactflux.jpg" style="height: 262px; width: 620px;" /></P><P>The chart would say: we have x contacts that was created at hour 6, y contacts created at hour 7, etc, etc.</P><P></P><P>The problem is: is that possible to display the number of contacts that were created at an hour+N?</P><P></P><P>The N is a variable that can be changed via a slider, and the bar chart will dynamically change as user moves the slider. If the N is set to 2, the contact ID 280880 will have 'Hour' value 10, contact 280995 will have 'Hour' value 13, etc., and this 'new values' will be shown in the chart. </P><P></P><P>The dimension is an inline table consisting number 1 to 24, to show 24 hour time.</P><P></P><P>Appreciate your help. Thanks.</P></BODY></HTML> Thu, 04 Feb 2016 10:16:33 GMT Anonymous 2016-02-04T10:16:33Z Dynamic dimension https://community.qlik.com/t5/QlikView/Dynamic-dimension/m-p/1048478#M352297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have table as follows (lets call it 'Contact' table):</P><P><IMG alt="datasource.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113533_datasource.jpg" style="height: auto;" /></P><P></P><P>And a chart that displays that Contact table:</P><P><IMG alt="contactflux.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/113544_contactflux.jpg" style="height: 262px; width: 620px;" /></P><P>The chart would say: we have x contacts that was created at hour 6, y contacts created at hour 7, etc, etc.</P><P></P><P>The problem is: is that possible to display the number of contacts that were created at an hour+N?</P><P></P><P>The N is a variable that can be changed via a slider, and the bar chart will dynamically change as user moves the slider. If the N is set to 2, the contact ID 280880 will have 'Hour' value 10, contact 280995 will have 'Hour' value 13, etc., and this 'new values' will be shown in the chart. </P><P></P><P>The dimension is an inline table consisting number 1 to 24, to show 24 hour time.</P><P></P><P>Appreciate your help. Thanks.</P></BODY></HTML> Thu, 04 Feb 2016 10:16:33 GMT https://community.qlik.com/t5/QlikView/Dynamic-dimension/m-p/1048478#M352297 Anonymous 2016-02-04T10:16:33Z Re: Dynamic dimension https://community.qlik.com/t5/QlikView/Dynamic-dimension/m-p/1048479#M352298 <HTML><HEAD></HEAD><BODY><P>Change your Hour dimension to a calculated dimension: =Hour+$(vOffSetVariable)</P></BODY></HTML> Thu, 04 Feb 2016 17:36:30 GMT https://community.qlik.com/t5/QlikView/Dynamic-dimension/m-p/1048479#M352298 Gysbert_Wassenaar 2016-02-04T17:36:30Z