topic Re: Add 'if' conditions to set analysis in QlikView

Add 'if' conditions to set analysis

leale1997 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Add 'if' conditions to set analysis

sunny_talwar — Thu, 18 Oct 2018 14:55:43 GMT

You can try this

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

Re: Add 'if' conditions to set analysis

leale1997 — Thu, 18 Oct 2018 17:41:30 GMT

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