Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Select only the available days of the month

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

Labels (2)
0 Replies