Hi guys, can you help me? I need to select only the available days of the month. In this example it would be data from 1 to 25 days
Expression
=Day(FECHA_TEMP)
let vMaxDate = '=max(FECHA_TEMP)';
let vMaxDay = '=day(max(FECHA_TEMP))';
let vMaxMonth = '=month(max(FECHA_TEMP))';
let vMaxYear = '=max(Year)';
let vPriorMonth = '=month(addmonths(max(FECHA_TEMP),-1))';
let vPriorMonthYear = '=Year(addmonths(max(FECHA_TEMP),-1))';
let vPriorYear = '=vMaxYear-1';
let vPriorYearDate = '=date(addyears(max(FECHA_TEMP),-1),' & chr(39) & 'DD MMM YYYY' & chr(39) & ')';
Let vReloadTime= '=Today()';
![qlik ejemplo.png qlik ejemplo.png](https://community.qlik.com/t5/image/serverpage/image-id/30625i196585DBEA1ACF74/image-size/large?v=v2&px=999)