topic Re: Table: Two columns as single dimension in App Development

Table: Two columns as single dimension

Thu, 11 Aug 2016 16:07:10 GMT

Hi there,

My data is log-type data looks like this

number	Opened time	opened_by	resolved_by
1	01/05/2016 00:00:00	H	W
2	01/05/2016 00:05:00	Y	G
3	01/05/2016 00:10:00	F	W
...	...	...	...

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:

Can anyone provide any direction? I attach the data.

Thanks,

Conor

Thu, 11 Aug 2016 16:36:15 GMT

folow

Gysbert_Wassenaar — Thu, 11 Aug 2016 16:36:54 GMT

See attached app.

Thu, 11 Aug 2016 16:38:11 GMT

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.

Fri, 12 Aug 2016 08:55:32 GMT

This was perfect! Thank you.