topic Convert to YTD expression in QlikView https://community.qlik.com/t5/QlikView/Convert-to-YTD-expression/m-p/1302386#M835869 <HTML><HEAD></HEAD><BODY><P>I have a expression that considers first day of a fiscal month to calculate a measure. How should I make it to display the users the measure for current year. I want it to consider first of every month for the selected year. I have the expression below</P><P>=num(if(sum({&lt;DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'&lt;=$(=max(FiscalDate))'}&gt;}if(match(Trim(Column1),Field1') .....),1,0)) &gt;0,</P><P>SUM({&lt;DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'&lt;=$(=max(FiscalDate))'}&gt;}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)))</P><P>/</P><P>SUM({&lt;DATEFIELD1={'$(=min(FiscalDate))'}&gt;}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)),'##.##%')</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Convert to YTD expression https://community.qlik.com/t5/QlikView/Convert-to-YTD-expression/m-p/1302386#M835869 <HTML><HEAD></HEAD><BODY><P>I have a expression that considers first day of a fiscal month to calculate a measure. How should I make it to display the users the measure for current year. I want it to consider first of every month for the selected year. I have the expression below</P><P>=num(if(sum({&lt;DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'&lt;=$(=max(FiscalDate))'}&gt;}if(match(Trim(Column1),Field1') .....),1,0)) &gt;0,</P><P>SUM({&lt;DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'&lt;=$(=max(FiscalDate))'}&gt;}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)))</P><P>/</P><P>SUM({&lt;DATEFIELD1={'$(=min(FiscalDate))'}&gt;}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)),'##.##%')</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-to-YTD-expression/m-p/1302386#M835869 2020-11-25T16:16:04Z