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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dates minstring/maxstring and sum if - Help

Hi,

I have been playing around with an existing project trying to replace pure expressions (for each year) to 1 single expression ever the Year dimension.

I have previously used Varbles for yearstart/yearend; I have now changed this in the expresion to maxstring(Date) and minstring(Date) which should return the 31/12/xxxx and 1/1/xxxx respectivly.

I am applying this within a sum(If statement and it seems to error out; does anyone have any idea where I am going wrong.

Many thanks

0 Replies