topic Select last month with data in QlikView https://community.qlik.com/t5/QlikView/Select-last-month-with-data/m-p/229221#M81174 <HTML><HEAD></HEAD><BODY><P>Each folder is independent counsel selection, ie selection does not lead to next or previous folder. Help to select the month that contains data. I'm working with spreadsheets and in some cases the data is not updated. So, I need to catch the last month that contains data, I got it with this expression: = MONTH (MAKEDATE (Only (ANO), COUNT (TOTAL (1 &lt;group = ('BENEFICIARIES'), YEAR = {$(#= Only ( YEAR ))}&gt;} distinct MES))) and this year I'm bringing to this formula: = YEAR (today ()); These two expressions are used in an action "Select Field" in the folder. <SPAN closure_uid_wvkol="65" style="background-color: #fff;" wc="Mas o problema é que cada pasta é independente de seleção, ao acionar outra pasta e selecionar qualquer outro ano, e depois voltar para a pasta tira a seleção do mês que contém dados na pasta que usa essa ação." xc="But the problem is that each folder is independent of selection, to trigger another folder and select any other year, and then back to the folder deselect the month that contains data in the folder that uses this action.">But the problem is that each folder is independent of selection, to trigger another folder and select any other year, and then back to the folder deselect the month that contains data in the folder that uses this action.<BR style="background-color: #fff;" /></SPAN></P></BODY></HTML> Wed, 21 Jul 2010 14:17:15 GMT 2010-07-21T14:17:15Z Select last month with data https://community.qlik.com/t5/QlikView/Select-last-month-with-data/m-p/229221#M81174 <HTML><HEAD></HEAD><BODY><P>Each folder is independent counsel selection, ie selection does not lead to next or previous folder. Help to select the month that contains data. I'm working with spreadsheets and in some cases the data is not updated. So, I need to catch the last month that contains data, I got it with this expression: = MONTH (MAKEDATE (Only (ANO), COUNT (TOTAL (1 &lt;group = ('BENEFICIARIES'), YEAR = {$(#= Only ( YEAR ))}&gt;} distinct MES))) and this year I'm bringing to this formula: = YEAR (today ()); These two expressions are used in an action "Select Field" in the folder. <SPAN closure_uid_wvkol="65" style="background-color: #fff;" wc="Mas o problema é que cada pasta é independente de seleção, ao acionar outra pasta e selecionar qualquer outro ano, e depois voltar para a pasta tira a seleção do mês que contém dados na pasta que usa essa ação." xc="But the problem is that each folder is independent of selection, to trigger another folder and select any other year, and then back to the folder deselect the month that contains data in the folder that uses this action.">But the problem is that each folder is independent of selection, to trigger another folder and select any other year, and then back to the folder deselect the month that contains data in the folder that uses this action.<BR style="background-color: #fff;" /></SPAN></P></BODY></HTML> Wed, 21 Jul 2010 14:17:15 GMT https://community.qlik.com/t5/QlikView/Select-last-month-with-data/m-p/229221#M81174 2010-07-21T14:17:15Z