Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert to YTD expression

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

=num(if(sum({<DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'<=$(=max(FiscalDate))'}>}if(match(Trim(Column1),Field1') .....),1,0)) >0,

SUM({<DATEFIELD1={'$(=min(FiscalDate))'},DATEFIELD2={'<=$(=max(FiscalDate))'}>}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)))

/

SUM({<DATEFIELD1={'$(=min(FiscalDate))'}>}IF(MATCH(TRIM(cOLUMN1),'FIELD1') .........),1,0)),'##.##%')

0 Replies