Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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