Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a filter "by the number of entries"

 

Hi, I'm trying to build a first dashboard with Qlikview:

 

 

The general theme is about customer service Management.

 

 

I have a table with all customer devices and a second table of all the service requests that have been received on these devices.

 

 

Table 1 is approximately the following structure:

 

[Device ID], [Customer], [Location], ...

 

 

Table 2 as:

 

[Ticket no.] [Device ID], [Incident Category], ...

 

 

For each service request a new ticket is opened, so there can be multiple tickets for a single device.

 

 

What I'd like to create is a query where I can filter based on the number of service requests per ticket.

 

 

something like this:

 

#Tickets | #Devices

 

0 | 130

 

1 | 257

 

2 | 83

 

3 | 174

 

... | ...

 

 

Does anyone have an idea?

 

 

Thank you very much

 

 

Philipp

 

0 Replies