topic Qlikview Pivot table issue with single expression in QlikView

Qlikview Pivot table issue with single expression

Wed, 25 Nov 2020 16:16:04 GMT

I have 6 dimensions and 3 expressions in my pivot table. Whichever dimensions or metrics user selects,only those will get displayed in pivot table.And i want view of table to be pivot up.

One of dimension is Months which is always selected. Now all my dimensions which are selected are coming in pivoted up view. But for expressions, if only one metric is selected then month and metric are coming are seperate columns. If more than 1 metric is selected then metrics are coming month wise where individual months are my columns which is correct pivot up view.

Does anyone know how to get correct pivot up view for single metric too?

Re: Qlikview Pivot table issue with single expression

vishsaggi — Wed, 09 Aug 2017 14:58:00 GMT

Can you share this sample you are working on for a quick look at it?

Re: Qlikview Pivot table issue with single expression

Fri, 11 Aug 2017 06:48:32 GMT

I can't do that.But i'll try to explain it little further.

From the images which i have attached -

Single metric image contains metric label at top and months as rows

Multiple metric contains months on top row and metrics as rows.

Basically metric and month entities are exchanging their positions in the images.

How do i get multiple metric type of view for single metric view too?

I tried to drag column in single metric view but its messing up table when i select multple metrics.

Re: Qlikview Pivot table issue with single expression

vishsaggi — Fri, 11 Aug 2017 14:18:02 GMT

I cant see any metric label in your single metric image. So can you send me another image of what exactly is your expected output? Something like below?

Re: Qlikview Pivot table issue with single expression

vishsaggi — Fri, 11 Aug 2017 14:22:28 GMT