Solved: . - Qlik Community

Prozyn · ‎2022-12-20

Rick2Foqus · ‎2022-12-23

Try writing an if statement like this:

IF(SUM({<Year = {"<$(= Year(Today()))" }>}Total_Sales) = 0, SUM({<Year = {"$(= Year(Today()))"}>} Total_Sales),)

View solution in original post

Rick2Foqus · ‎2022-12-23

Try writing an if statement like this:

IF(SUM({<Year = {"<$(= Year(Today()))" }>}Total_Sales) = 0, SUM({<Year = {"$(= Year(Today()))"}>} Total_Sales),)

.

General Question