Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Creator II

## Measures as rows in pivot table

Hello,

I need to use my measures as pivot table rows. Is it doable with standard pivot table object?

An example of desired result is like below;

 Company-1 Company-2 Company-3 Avg. Rent 100 150 200 Avg. M2 10 20 50 Avg. Rent/m2 10 7,5 4
Labels (2)

• ### Qlik Sense

2 Solutions

Accepted Solutions

You can create static dimension for that with measures like

Dimensions

Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')

Company // Drag this to row

Measure

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent', Expression for Avg. Rent,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. M2', Expression for Avg. M2,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent/m2', Expression for Avg. Rent/m2)))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Employee

Hi,

Here is what it looks like using your data.

Also attached the qvf.

Regards,

Patrik.

9 Replies

You can create static dimension for that with measures like

Dimensions

Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')

Company // Drag this to row

Measure

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent', Expression for Avg. Rent,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. M2', Expression for Avg. M2,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent/m2', Expression for Avg. Rent/m2)))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator II
Author
Thank you so much!
Employee

You can also just move the measure values to row and the dimension to column.

Creator II
Author

Thanks for your reply but i couldn't find the way to do this. Can you provide me a sample qvf?

Creator II
Author

One last question.

I am using 2 dimensions in my pivot table. First one is month and second one is valuelist dimension. What if i want to get totals for each valuelist dims? Adding sums of those dims to valuelist function doesn't work since there is an another dimension exists.

I'm trying to achieve something like this;

Employee

Hi,

Here is what it looks like using your data.

Also attached the qvf.

Regards,

Patrik.

Employee

And here is a video of what I did.

Regards,

Patrik.

Creator II
Author

Thank you so much!

Contributor II

Thank you very much for this! It's exactly what I needed.

Tags
Community Browser