Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jordanhertl
Contributor

Is there a way to display measures vertically in a pivot table?

I am not finding this as an option to have my measures be the rows.

Is there an extension that anyone knows about that allows this?

3 Replies
Khan_Mohammed
Honored Contributor II

Re: Is there a way to display measures vertically in a pivot table?

It depends how you want it...

Can you show us a sample of what exactly your measure/dimensions are?

OmarBenSalem
Esteemed Contributor

Re: Is there a way to display measures vertically in a pivot table?

Yes you can;

Suppose u have 2 measures u want to show, sum(Expression1) and sum(Expression2) for example.

create a pivot table; as a dimension:

ValueList('Measure1','Measure2')

as a measure:

if(ValueList('Measure1','Measure2')='Measure1', sum(Expression1),sum(Expression2))

result:

Capture.PNG

Re: Is there a way to display measures vertically in a pivot table?

Not understand exactly what you need? You title looks Vertical ?? What you mean that, Does it mean related Label ??

Life is so rich, and we need to respect to the life !!!