topic Weekname - switching between Date and Week in QlikView https://community.qlik.com/t5/QlikView/Weekname-switching-between-Date-and-Week/m-p/194591#M55429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to be able to cycle between date (a timestamp) and week number in a graph. I use the function weekname(date) to calculate the weeknumber. However I would like my graph to show dates with missing data (for instance due to a particular selection) - this means I need to use the <EM>continuous</EM> option for this axis. However for the weeks option, this gives a strange number representation on the axis. Then I need to have the continuous option unchecked, which is not what I want... The solution needs to be able to cope with shift of year, so that week 50 in 2009 is interpreted as 'younger' than let's say week 1 in 2010.</P><P>Phrased differently, how can I cylce between date and week and still have an axis that 'makes sense'?</P><P>/regards Erik</P></BODY></HTML> Thu, 09 Sep 2010 11:12:06 GMT 2010-09-09T11:12:06Z Weekname - switching between Date and Week https://community.qlik.com/t5/QlikView/Weekname-switching-between-Date-and-Week/m-p/194591#M55429 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to be able to cycle between date (a timestamp) and week number in a graph. I use the function weekname(date) to calculate the weeknumber. However I would like my graph to show dates with missing data (for instance due to a particular selection) - this means I need to use the <EM>continuous</EM> option for this axis. However for the weeks option, this gives a strange number representation on the axis. Then I need to have the continuous option unchecked, which is not what I want... The solution needs to be able to cope with shift of year, so that week 50 in 2009 is interpreted as 'younger' than let's say week 1 in 2010.</P><P>Phrased differently, how can I cylce between date and week and still have an axis that 'makes sense'?</P><P>/regards Erik</P></BODY></HTML> Thu, 09 Sep 2010 11:12:06 GMT https://community.qlik.com/t5/QlikView/Weekname-switching-between-Date-and-Week/m-p/194591#M55429 2010-09-09T11:12:06Z Weekname - switching between Date and Week https://community.qlik.com/t5/QlikView/Weekname-switching-between-Date-and-Week/m-p/194592#M55430 <HTML><HEAD></HEAD><BODY><P>Hi Erikper,</P><P>You could make a master calendar using autogenerate table with all the dates and join your current data, in that way you will have all weeks even with no data.</P><P>I hope it's helps you.</P><P>Regards.</P><P></P></BODY></HTML> Thu, 09 Sep 2010 11:40:33 GMT https://community.qlik.com/t5/QlikView/Weekname-switching-between-Date-and-Week/m-p/194592#M55430 2010-09-09T11:40:33Z