topic Graph, Percentage By month & YearToMonth in 1 in QlikView https://community.qlik.com/t5/QlikView/Graph-Percentage-By-month-YearToMonth-in-1/m-p/168310#M39513 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm looking for a way to show a percentage value (Avt vs budget) and the year to month value of the same calculation in 2 lines on one graph.</P><P></P><P>=(SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsDayTotal Tickets])-SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsForecast Tickets]))/SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsForecast Tickets])</P><P>This goes over the month dimension.</P><P>Totalizing the percentages resuls of course in a wrong value.</P><BR /><BR /></BODY></HTML> Sun, 29 Nov 2009 03:36:24 GMT 2009-11-29T03:36:24Z Graph, Percentage By month & YearToMonth in 1 https://community.qlik.com/t5/QlikView/Graph-Percentage-By-month-YearToMonth-in-1/m-p/168310#M39513 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm looking for a way to show a percentage value (Avt vs budget) and the year to month value of the same calculation in 2 lines on one graph.</P><P></P><P>=(SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsDayTotal Tickets])-SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsForecast Tickets]))/SUM({&lt;[Date Year]={$(Dash_SelYear)} &gt;} [TsForecast Tickets])</P><P>This goes over the month dimension.</P><P>Totalizing the percentages resuls of course in a wrong value.</P><BR /><BR /></BODY></HTML> Sun, 29 Nov 2009 03:36:24 GMT https://community.qlik.com/t5/QlikView/Graph-Percentage-By-month-YearToMonth-in-1/m-p/168310#M39513 2009-11-29T03:36:24Z