Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Tags (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Table: Two columns as single dimension

See attached app.


talk is cheap, supply exceeds demand
4 Replies
Not applicable

Re: Table: Two columns as single dimension

folow

Gysbert_Wassenaar
Not applicable

Re: Table: Two columns as single dimension

See attached app.


talk is cheap, supply exceeds demand
Not applicable

Re: Table: Two columns as single dimension

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

Re: Table: Two columns as single dimension

This was perfect! Thank you.