Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table: Two columns as single dimension

Hi there,

My data is log-type data looks like this

numberOpened timeopened_byresolved_by
101/05/2016  00:00:00HW
201/05/2016  00:05:00YG
301/05/2016  00:10:00FW
............

Where opened_by and resolved_by detail individuals who opened and resolved an incident.

I want to create a table (either flat or pivot) that looks like this:

IndividualNo of incidents openedNo of incidents resolved
A125
B814
C2115
.........

Can anyone provide any direction? I attach the data.

Thanks,

Conor

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached app.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable
Author

folow

Gysbert_Wassenaar

See attached app.


talk is cheap, supply exceeds demand
Not applicable
Author

I can't seem to open this in Qlik Sense. When I put it in my apps and open it in Desktop no sheets appear.

Not applicable
Author

This was perfect! Thank you.