Pivot Table help with Expression????

amit_saini — Fri, 09 May 2014 06:26:37 GMT

Hi Folks ,

I'm having a pivot table which looks like below:

Here I'm having Expression as Downtime-Cat-Desc. and Downtime , where in Downtime -Cat-Desc. I'm having few names like "Paro Fin de Semana" and in Downtime I'm having some time data.

I need them in this way as Horizontal look: Similar I want with Scrap-Cat-Desc. and Scrap.

Downtime-Cat-Desc.	Arranque/Paro Máquina	Falta de planificación	Cambio de molde/Ajuste	Equipo intermedio	Fallo en sopladora	TPM	Problema/Error logística	Otros (fugas, molino, etc.)	Fallo herramientas	-
	247:13:37	118:07:41	33:40:00	13:14:18	9:33:12	8:00:00	2:00:00	1:46:39	1:09:44	1533:23:29

Please see the attachment 123.qvw for more details .

Thanks in advance.

Re: Pivot Table help with Expression????

Gysbert_Wassenaar — Fri, 09 May 2014 08:17:50 GMT

Add those fields as dimensions instead of expressions. Then drag those dimensions to above the expressions so they are pivoted to horizontal layout.

Re: Pivot Table help with Expression????

sujeetsingh — Fri, 09 May 2014 08:22:08 GMT

Gylberst is right

topic Re: Pivot Table help with Expression???? in QlikView

Pivot Table help with Expression????

Re: Pivot Table help with Expression????

Re: Pivot Table help with Expression????