Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
parvez933
New Contributor III

Calculations

Hi Everyone!

Can anyone, please help me the transformation logic for the shared details. Where I have to calculate

1. Count of Tickets Based on creation Date

2. Count of Open Tickets based on creation Date

3. Count of Closed Tickets based on closed Date

4. Count of Closed Tickets within SLA [Within SLA are the tickets which are closed prior/equal to resolution date]

5. Count of InProgress tickets based on creation count.

4 Replies
shiveshsingh
Honored Contributor

Re: Calculations

Hi

After loading data in qlik, 

Take Creation Date as Dimension and then Count(ID) as expression.

Accordingly you can change the expression - Count({<Status = {'Open'}>}ID)

Count({<Status = {'Closed'}>}ID)

Count({<Status = {'InProgress'}>}ID)

parvez933
New Contributor III

Re: Calculations

Hi ShiveshSingh,

Can you also please help me in calculating number of tickets landed within an hour.
parvez933
New Contributor III

Re: Calculations

Hi!

Anyone can help me with the SLA. How to calculate the SLA based on creation date and resolution date
MVP & Luminary
MVP & Luminary

Re: Calculations

I think you'll want to create reference dates to cover the intervals between opening and closing dates. See this blog post for more information: https://community.qlik.com/t5/Qlik-Design-Blog/Creating-Reference-Dates-for-Intervals/ba-p/1463944


talk is cheap, supply exceeds demand