Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Qlikview Pivot table issue with single expression

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?

4 Replies
vishsaggi
Esteemed Contributor III

Re: Qlikview Pivot table issue with single expression

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

Not applicable

Re: Qlikview Pivot table issue with single expression

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.

vishsaggi
Esteemed Contributor III

Re: Qlikview Pivot table issue with single expression

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?

Capture.PNG

vishsaggi
Esteemed Contributor III

Re: Qlikview Pivot table issue with single expression

Or

Capture.PNG