topic Visual indicator for select Year en Year-1 in QlikView https://community.qlik.com/t5/QlikView/Visual-indicator-for-select-Year-en-Year-1/m-p/221443#M74253 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt;Year = {$(ONLY(Year))}&gt;} Sales)<BR />Sum({&lt;Year = {$(ONLY(Year) - 1)}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P>That will work if you only have one year selected. If you're going to allow multiple year selections, it will be different (but then how do you define year -1).</P><P></P></BODY></HTML> Wed, 21 Oct 2009 23:14:19 GMT 2009-10-21T23:14:19Z Visual indicator for select Year en Year-1 https://community.qlik.com/t5/QlikView/Visual-indicator-for-select-Year-en-Year-1/m-p/221442#M74252 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have an visual indicator(sum(sales)), i wnat to view sales for the select year end for the Year-1 in the same graphe(histogramme).</P><P>How can i do it?</P><P></P><P>Thanks</P><P></P></BODY></HTML> Wed, 21 Oct 2009 22:57:18 GMT https://community.qlik.com/t5/QlikView/Visual-indicator-for-select-Year-en-Year-1/m-p/221442#M74252 2009-10-21T22:57:18Z Visual indicator for select Year en Year-1 https://community.qlik.com/t5/QlikView/Visual-indicator-for-select-Year-en-Year-1/m-p/221443#M74253 <HTML><HEAD></HEAD><BODY><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt;Year = {$(ONLY(Year))}&gt;} Sales)<BR />Sum({&lt;Year = {$(ONLY(Year) - 1)}&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P>That will work if you only have one year selected. If you're going to allow multiple year selections, it will be different (but then how do you define year -1).</P><P></P></BODY></HTML> Wed, 21 Oct 2009 23:14:19 GMT https://community.qlik.com/t5/QlikView/Visual-indicator-for-select-Year-en-Year-1/m-p/221443#M74253 2009-10-21T23:14:19Z