6 Replies Latest reply: Aug 6, 2010 8:00 AM by Richard Fenner RSS

    How to Count Dormant Members Qlikview 8.5

    Richard Fenner

      Hi There,

      I am trying to count all the members that haven't made a sale in the last 6 months.

      I'm guessing it would be something like this: count({$<~YearMonth = {'201007','201006','201005','201004','201003','201002'}>}distinct MemberNo)

      but i am trying to automate it so that i do not have to manually change the expression every time 1 month passes.

      Help would be much appreciated.