1 Reply Latest reply: Jan 26, 2018 4:57 AM by Jon Ridgway RSS

    Problem with format for set analysis

    Jon Ridgway

      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.