topic Calculated Dimension to change the Dimension Labels? in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-change-the-Dimension-Labels/m-p/323690#M586958 <HTML><HEAD></HEAD><BODY><P>I want to look at a year over year trend chart (a line chart in this case) by week.&nbsp; I want the chart to look at the trends by [Week No], but I want to display the [Week] dates by the current year dates.&nbsp; Can I do this using a cacluated dimension?&nbsp; I have tried a few caclulations, but have not gotten anything to work.&nbsp; I am new to the developer side of QV and haven't really used cacluated dimensions yet.&nbsp; Does anyone have any suggestions?&nbsp; Any help would be appreciated.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 24 May 2011 15:44:30 GMT 2011-05-24T15:44:30Z Calculated Dimension to change the Dimension Labels? https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-change-the-Dimension-Labels/m-p/323690#M586958 <HTML><HEAD></HEAD><BODY><P>I want to look at a year over year trend chart (a line chart in this case) by week.&nbsp; I want the chart to look at the trends by [Week No], but I want to display the [Week] dates by the current year dates.&nbsp; Can I do this using a cacluated dimension?&nbsp; I have tried a few caclulations, but have not gotten anything to work.&nbsp; I am new to the developer side of QV and haven't really used cacluated dimensions yet.&nbsp; Does anyone have any suggestions?&nbsp; Any help would be appreciated.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 24 May 2011 15:44:30 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-change-the-Dimension-Labels/m-p/323690#M586958 2011-05-24T15:44:30Z Calculated Dimension to change the Dimension Labels? https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-change-the-Dimension-Labels/m-p/323691#M586959 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I guess yes, a calculated dimension will do the trick... Try looking into the Dual function.</P><P></P><P>Mike.</P></BODY></HTML> Tue, 24 May 2011 15:59:21 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension-to-change-the-Dimension-Labels/m-p/323691#M586959 mike_garcia 2011-05-24T15:59:21Z