Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
marinadzuba
New Contributor

Counting number of items with date later than specified period

Dear Qlik Community,

I have requirement to calculate a number of items that were still outstanding at the end of each reporting period.

I have a RECEIVED_DATE for each item, and a COMPLETED_DATE.  Items are placed into a month-period based on the RECEIVED_DATE (I have a table which displays RECEIVED_DATE.autoCalendar.YearMonth).

For each RECEIVED_DATE.autoCalendar.YearMonth, I need a count of items where the COMPLETED_DATE was later than this period.  I am trying to configure a measure column with set analysis to do this count but just can't seem to get the syntax right.  Following many searches on these forums some of the syntax I've tried are:

Count({< MasterDate = {">=$(=RECEIVED_DATE.autoCalendar.YearMonth<=$(COMPLETED_DATE.autoCalendar.YearMonth)"} >} ITEM_REF)

count({<COMPLETED_DATE={"$(= '>=' & '01/01/2014')"}>} distinct ITEM_REF

= count({<COMPLETED_DATE= {">$(=RECEIVED_DATE.autoCalendar.YearMonth)"}> } ITEM_REF)

COUNT({<[COMPLETED_DATE] = {"<= [RECEIVED_DATE.autoCalendar.YearMonth]"} >}ITEM_REF)

This may be a simple thing to achieve but I am very new and struggling.

Please help?   Thank you!

Tags (2)
1 Reply
zebhashmi
Valued Contributor

Re: Counting number of items with date later than specified period

Count ({COMPLETED_DATE={">$(RECEIVED_DATE +30)"}ITEM_REF)


Count(if(COMPLETED_DATE>RECEIVED_DATE+30,ITEM_REF)