topic Re: Set analysis in QlikView

Set analysis

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

Hello,

I am trying this Set Analysis. My logic is I want to count all distinct Incident that are open more that 21 days f Report date of incident . %DayId is my Report date of Incident . Please suggest . I believe there is some error in Set analysis.

count ( {<%DayId > {%DayId+21}>}distinct MOR_IncidentId)

Niha

Re: Set analysis

Gysbert_Wassenaar — Fri, 02 Nov 2018 15:20:49 GMT

How do you know if an incident is still open? The report date of incident only tells us when it was opened.

Re: Set analysis

Jesh19 — Fri, 02 Nov 2018 15:34:20 GMT

Try the below expression

Count({<%DayID={">%DayID+21"},Status={'Open'}>}distinct MOR_IncidentID)

Here Status should be your Incident Status.

Re: Set analysis

niharika1234 — Fri, 02 Nov 2018 17:07:19 GMT

Thanks.

Re: Set analysis

niharika1234 — Fri, 02 Nov 2018 17:07:34 GMT

Thanks.

Re: Set analysis

juraj_misina — Fri, 02 Nov 2018 22:29:03 GMT

Hi,

I assume that you compare the report date of incident with today, so I'd try this:

count ( {<%DayId={"<=$(=Today()-21)"}>}distinct MOR_IncidentId)

This will select all incidents which were reported 21 days ago or earlier, so you also need to account for "open" incidents (as Gysbert mentions, you did not specify how you define an open incident).