Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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.

rachelridgway
New Contributor

Problem with format for set analysis

Hi,

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
rachelridgway
New Contributor

Re: Problem with format for set analysis

Hi,

FYI. Found the problem, expression should be:

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

Regards,

Jon.