Setting flags

Thu, 20 Oct 2011 22:00:10 GMT

I have a Master Calendar (based on PITR example) that is used to select date range.

Includes dates:

Date

SalesDate

I have Sales Data that includes:

SalesDate

ProductCode

Product-CreatedDate

OrderedDate

Could you please guide me as to how I can achieve (flag?) settings in my script, so that I can (for example)

- count the number of distinct products that were created in the selected date range (new products)

- count the number of distinct products that were created outside of the selected date range (old products)

- count the number of distinct products created in the selected date range and that were ordered in the selected date range (new products ordered in this date range).

Many thanks

topic Setting flags in QlikView

Setting flags