Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Partner
Partner

Here my example i hope this helps

View solution in original post

2 Replies
Highlighted
Partner
Partner

Here my example i hope this helps

View solution in original post

Highlighted
Contributor II
Contributor II

Thank you - works exactly how I want it to.

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