topic Set Analysis problem with last year in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261360#M582268 <HTML><HEAD></HEAD><BODY><P>Hi Dear Community</P><P></P><P></P><P>I have this problem with set analysis, i have this expression</P><P></P><P>Money((Sum({&lt;Año={$(#=Only(Año)-1)}&gt;} Valor_PyG/$(vMoneda_PyG))/If(GetFieldSelections(MONEDA)='COP',1000000,1000))</P><P></P><P>The expression works fine with one ore more month selected but if i don't have months selected the value is zero.</P></BODY></HTML> Mon, 28 Nov 2011 15:55:42 GMT 2011-11-28T15:55:42Z Set Analysis problem with last year https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261360#M582268 <HTML><HEAD></HEAD><BODY><P>Hi Dear Community</P><P></P><P></P><P>I have this problem with set analysis, i have this expression</P><P></P><P>Money((Sum({&lt;Año={$(#=Only(Año)-1)}&gt;} Valor_PyG/$(vMoneda_PyG))/If(GetFieldSelections(MONEDA)='COP',1000000,1000))</P><P></P><P>The expression works fine with one ore more month selected but if i don't have months selected the value is zero.</P></BODY></HTML> Mon, 28 Nov 2011 15:55:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261360#M582268 2011-11-28T15:55:42Z Set Analysis problem with last year https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261361#M582269 <HTML><HEAD></HEAD><BODY><P>Do you get an unambiguous value for Ano if you don't have months selected (watch field list box Ano while selecting / unselecting months)? I assume your only(Ano) is returning NULL.</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Mon, 28 Nov 2011 16:03:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261361#M582269 swuehl 2011-11-28T16:03:36Z Set Analysis problem with last year https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261362#M582270 <HTML><HEAD></HEAD><BODY><P>I solved my problem add this part in set analysis Mes ,Mes={"&lt;=$(vMaxMes)"} Thanks For all</P></BODY></HTML> Mon, 28 Nov 2011 18:54:25 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-problem-with-last-year/m-p/261362#M582270 2011-11-28T18:54:25Z