1 Reply Latest reply: Mar 28, 2013 3:27 AM by Kaushik Solanki RSS

    Date Count

      Hi all,

      My requirement is, want to convert this expression to qlikview expression.

      Here we are taking [Start Date] and [End Date] from the calendar variable, mean to say dynamically and finally i want total count of all the counts.

       

      Case

      WHEN [Receive Date] BETWEEN [Start Date] AND [End Date]

      AND [Policy Symbol] IN ('MAC', 'PAC', 'GLP', 'CPP')

      THEN 1

      ELSE 0

      END