topic Chart with two Dimensions in QlikView https://community.qlik.com/t5/QlikView/Chart-with-two-Dimensions/m-p/205225#M61803 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I am working on making an application about exchange rates. In the chart a line should be plotted about the daily exchange rate, but on the X-axis only the months should be mentioned (see QVW-file).</P><P>If have tried this with dual(Month, Date) as a calculated dimension. The problem here is that on every date the month is mentioned and I would like to have the month mentioned only on the X-axis on the first date of the month and not repeated on each date. I have tried to do this with below formula:</P><P style="font-weight: bold"></P><P style="font-weight: bold">= dual(if(floor(Date) = floor(MonthStart(Date)), Month(floor(MonthStart(Date))), '') , Date)</P><BR /><BR /> <P>This however does not work as not for each month there is a value for the 1st of the month. I need a formula that selects the first date in each month (for example 02-11-2009) and then give the monthname on the X-axis and otherwise ' '.</P><P>Does someone have a solution for this issue?</P><P>Regards, Douwe</P></BODY></HTML> Fri, 08 Jan 2010 10:49:32 GMT 2010-01-08T10:49:32Z Chart with two Dimensions https://community.qlik.com/t5/QlikView/Chart-with-two-Dimensions/m-p/205225#M61803 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>I am working on making an application about exchange rates. In the chart a line should be plotted about the daily exchange rate, but on the X-axis only the months should be mentioned (see QVW-file).</P><P>If have tried this with dual(Month, Date) as a calculated dimension. The problem here is that on every date the month is mentioned and I would like to have the month mentioned only on the X-axis on the first date of the month and not repeated on each date. I have tried to do this with below formula:</P><P style="font-weight: bold"></P><P style="font-weight: bold">= dual(if(floor(Date) = floor(MonthStart(Date)), Month(floor(MonthStart(Date))), '') , Date)</P><BR /><BR /> <P>This however does not work as not for each month there is a value for the 1st of the month. I need a formula that selects the first date in each month (for example 02-11-2009) and then give the monthname on the X-axis and otherwise ' '.</P><P>Does someone have a solution for this issue?</P><P>Regards, Douwe</P></BODY></HTML> Fri, 08 Jan 2010 10:49:32 GMT https://community.qlik.com/t5/QlikView/Chart-with-two-Dimensions/m-p/205225#M61803 2010-01-08T10:49:32Z