topic Change Refernce Line based on Dimension in QlikView https://community.qlik.com/t5/QlikView/Change-Refernce-Line-based-on-Dimension/m-p/294971#M578660 <HTML><HEAD></HEAD><BODY><DIV>Good Afternoon,</DIV><DIV> </DIV><DIV>I am trying to replace a Tableu report in QlikView and am having trouble with the reference lines.&nbsp; I would like the reference line to be calculated separately over different months, but be able to view multiple months in the chart.&nbsp; Please see attached JPEG.&nbsp; Right now I am using the expression:<SPAN style="font-size: 8pt;"><DIV>=(</DIV></SPAN></DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Year]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Month]</SPAN><SPAN style="font-size: 8pt;">&gt;<BR /> <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Time Hours]</SPAN><SPAN style="font-size: 8pt;">)/8)<BR /> /<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Year]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Month]</SPAN><SPAN style="font-size: 8pt;">&gt;<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Kronos]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></DIV><DIV> </DIV><DIV>The reference line doesn't not take the dimension into account.</DIV><DIV> </DIV><DIV>Any help would be appreciated.</DIV><DIV> </DIV><DIV>Thanks,</DIV><DIV> </DIV><DIV>Jacob N. Dockendorf </DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Fri, 17 Feb 2012 15:38:30 GMT jdf 2012-02-17T15:38:30Z Change Refernce Line based on Dimension https://community.qlik.com/t5/QlikView/Change-Refernce-Line-based-on-Dimension/m-p/294971#M578660 <HTML><HEAD></HEAD><BODY><DIV>Good Afternoon,</DIV><DIV> </DIV><DIV>I am trying to replace a Tableu report in QlikView and am having trouble with the reference lines.&nbsp; I would like the reference line to be calculated separately over different months, but be able to view multiple months in the chart.&nbsp; Please see attached JPEG.&nbsp; Right now I am using the expression:<SPAN style="font-size: 8pt;"><DIV>=(</DIV></SPAN></DIV><DIV><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Year]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Month]</SPAN><SPAN style="font-size: 8pt;">&gt;<BR /> <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Time Hours]</SPAN><SPAN style="font-size: 8pt;">)/8)<BR /> /<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;"> &lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Year]</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Month]</SPAN><SPAN style="font-size: 8pt;">&gt;<BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Date Posted Kronos]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></DIV><DIV> </DIV><DIV>The reference line doesn't not take the dimension into account.</DIV><DIV> </DIV><DIV>Any help would be appreciated.</DIV><DIV> </DIV><DIV>Thanks,</DIV><DIV> </DIV><DIV>Jacob N. Dockendorf </DIV><DIV> </DIV><DIV> </DIV></BODY></HTML> Fri, 17 Feb 2012 15:38:30 GMT https://community.qlik.com/t5/QlikView/Change-Refernce-Line-based-on-Dimension/m-p/294971#M578660 jdf 2012-02-17T15:38:30Z