Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
niharika1234
Creator
Creator

Set analysis

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

5 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Jesh19
Creator II
Creator II

Try the below expression

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

Here Status should be your Incident Status.

niharika1234
Creator
Creator
Author

Thanks.

niharika1234
Creator
Creator
Author

Thanks.

juraj_misina
Luminary Alumni
Luminary Alumni

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).