https://community.qlik.com/t5/QlikView/Update-existing-Dimension-with-variable/m-p/1765500#M591032 <P>Hi All</P><P>We have a reaasonably complex document which utilises a calendar dimension which includes as you may expect a Week field.&nbsp; This is a numberic value at present.</P><P>For 2021 we need to report an offset in the weeks year on year, so week 2 2021 for example will show against week 3 2020.&nbsp;</P><P>Can build it in a simple model by having two new fields in the source load which detail the offset as required using the likes of&nbsp;=if(GetFieldSelections(year)=2021,weekoffset,weekstd) as a calculated dimension.</P><P>The question is, yes i got there in the end ...</P><P>As the document is complex and Week is used in numerous charts is there a way to amend the value currently being loaded as Week from say 1 to something that the existing charts would interpret as the above calculation thus not having to go in and amend all the charts?</P><P>some based same files attached to hopefully explain it better</P><P>Thanks&nbsp;</P><P>Mo</P> Fri, 15 Nov 2024 23:32:12 GMT musmo_2049 2024-11-15T23:32:12Z https://community.qlik.com/t5/QlikView/Update-existing-Dimension-with-variable/m-p/1765500#M591032 <P>Hi All</P><P>We have a reaasonably complex document which utilises a calendar dimension which includes as you may expect a Week field.&nbsp; This is a numberic value at present.</P><P>For 2021 we need to report an offset in the weeks year on year, so week 2 2021 for example will show against week 3 2020.&nbsp;</P><P>Can build it in a simple model by having two new fields in the source load which detail the offset as required using the likes of&nbsp;=if(GetFieldSelections(year)=2021,weekoffset,weekstd) as a calculated dimension.</P><P>The question is, yes i got there in the end ...</P><P>As the document is complex and Week is used in numerous charts is there a way to amend the value currently being loaded as Week from say 1 to something that the existing charts would interpret as the above calculation thus not having to go in and amend all the charts?</P><P>some based same files attached to hopefully explain it better</P><P>Thanks&nbsp;</P><P>Mo</P> Fri, 15 Nov 2024 23:32:12 GMT https://community.qlik.com/t5/QlikView/Update-existing-Dimension-with-variable/m-p/1765500#M591032 musmo_2049 2024-11-15T23:32:12Z