Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Complex set analysis - dates.

Hi,

I have to display a metric: number of items that have been in the database for over a year and don't have a review data or an owner.

These are the fields I need for it:

ItemID

Owner - owner of the item

PublishDate - when items was added

vToday - variable - todays date

I'm not sure how to tackle this. Any ideas?

1 Solution

Accepted Solutions
anbu1984
Honored Contributor III

Re: Complex set analysis - dates.

Count({<Owner={"=len(trim(Owner))=0"},PublishDate={"$(= '>=' & date(vToday) & '<=' & date(vToday-365))"}>}ItemID)

2 Replies
anbu1984
Honored Contributor III

Re: Complex set analysis - dates.

Count({<Owner={"=len(trim(Owner))=0"},PublishDate={"$(= '>=' & date(vToday) & '<=' & date(vToday-365))"}>}ItemID)

Re: Complex set analysis - dates.

Provide some sample data please !

Community Browser