Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

a function for "incidents which is in progress more than 10 days"

hi

i am trying to take the number of incidents which is in progress more than 10 days... "in progress" sate is in the status table and i take the incident count from the incident table,, can some one tell me how to get this calculation plz

thank you in advance

6 Replies
Not applicable

Re: a function for "incidents which is in progress more than 10 days"

would you be able to share a qvw or some sample data?

Not applicable

Re: Re: a function for "incidents which is in progress more than 10 days"

i have attached my qvw.. hear i want to take the total number of incidents which is in pending state more than to day..

fkeuroglian
Honored Contributor

Re: a function for "incidents which is in progress more than 10 days"

hi, i suppose you have a date for each incident? in this case you could use DateDiff or Interval Match Functions to calculate the amount of days that each incident have.

in your expression you could use something like:

if(today()  - dateIncident)>9, red(),green()) in the format color in expression

please put and example qvw to be easier help you

Fernando

venkatasreekant
Valued Contributor

Re: Re: Re: a function for "incidents which is in progress more than 10 days"


Hi,

The following attachment might help you....

Not applicable

Re: a function for "incidents which is in progress more than 10 days"

hi

i have attached an example above.. i need to take a count of all the in progress incidents more than 10 days. is there a possible way??

Not applicable

Re: Re: Re: a function for "incidents which is in progress more than 10 days"

hi Venkata

i am using a personal edition so i am unable to open your attachment will it be possible for you to send me some screen shots plzzz ???

Community Browser