Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create table by age of ticket

Hi. newbie here, trying to work my way through a number of issues.

The main issue is trying to create a cross table showing a count of volumes depending on the age of the ticket.

I have attached an image of what i am trying to achieve in terms of displaying the volumes - but not sure how i can get qlikview to do this?

I also attach the raw data, which contains the actual columns i wish to display (the image below is just for a visual reference). i dont need the totals or subtotals - just the count of Age broken down into the aged periods.

The field 'Age' contains the data I am trying to plot, against customer, Assigned team and create date.

Any guidance would be appreciated

table.JPG

1 Solution

Accepted Solutions
francisvandergr
Partner - Creator II
Partner - Creator II

Here my example i hope this helps

View solution in original post

2 Replies
francisvandergr
Partner - Creator II
Partner - Creator II

Here my example i hope this helps

Anonymous
Not applicable
Author

Thank you - works exactly how I want it to.

I have some more challenges, but will post a new query