Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

New Contributor

Problem with format for set analysis


I've been trying to get this simple expression to work. Keeps returning 0. However given my data set I know it should return 1059 (as it does when I try with an if statement - which I can't use as when I get it working I need to restrict the set further in the expression). Can any one spot any obvious mistake in the statement:

=count ({$<[Last Approved Date] = {"$(>AddMonths(Today(),-12))"}>}[Package GUID])

I'm after a count of the number of packages (Package GUID) that have a Last Approved Data > 1 year ago.

PS. I'm very new to Qlikview, so apologies if this is obvious / posted to the wrong group.

1 Reply
New Contributor

Re: Problem with format for set analysis


FYI. Found the problem, expression should be:

=count ({$<[Last Approved Date] = {">=$(=AddMonths(Today(),-12))"}>}[Package GUID])