Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Add 'if' conditions to set analysis

Not good at Set Analytics AT ALL

I found a formula and adapted it for my needs and it is working, partly....

I have a set of data and I want to count every record in that table that is:

     - closed late in the current month.

     - Has a [project] field that = 'New' or 'Assessed'

     - Has a [status] field that = 'Late'

This is what I have so far that is working.  But it's just counting everything that closed in the month of October with no added variables applied.

=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}>} RecordID)

Any ideas or examples?

1 Solution

Accepted Solutions
Highlighted

You can try this

=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}, project = {'New', 'Assessed'}, status = {'Late'}>} RecordID)

View solution in original post

2 Replies
Highlighted

You can try this

=Count({<DateClosed = {"$(='>=' & Date(MonthStart(Today())) & '<=' & Date(MonthEnd(Today())))"}, project = {'New', 'Assessed'}, status = {'Late'}>} RecordID)

View solution in original post

Highlighted
Contributor III
Contributor III

That worked!  Thanks!  Sorry for the delay.  Found issues in the data I was trying to solve..