Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys. I'm trying to write a basic Set expression for a chart expression to just return the number of people with end dates on the selected date.
count({$<[End Date] = Date>} [Person Number])
Qlikview underlines everything after the '>' as an error and no data is generated. It looks like I have the right syntax. Any idea why this generates an error?
Mike
Try with
count({$<[End Date] = {'$(=Max(Date))'}>} [Person Number])