Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mfarsln
Creator II
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-1Company-2Company-3
Avg. Rent100150200
Avg. M2102050
Avg. Rent/m2107,54
Labels (2)
2 Solutions

Accepted Solutions
Anil_Babu_Samineni

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)))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)

View solution in original post

Patrik_Lundblad
Employee
Employee

Hi,

Here is what it looks like using your data.

Pivot example.PNG

Also attached the qvf. 

Regards,

Patrik.

View solution in original post

9 Replies
Anil_Babu_Samineni

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)))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
mfarsln
Creator II
Creator II
Author

Thank you so much!
Patrik_Lundblad
Employee
Employee

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

 

Pivot table.PNG

mfarsln
Creator II
Creator II
Author

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

mfarsln
Creator II
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;

 

 

Ekran Alıntısı.PNG

Patrik_Lundblad
Employee
Employee

Hi,

Here is what it looks like using your data.

Pivot example.PNG

Also attached the qvf. 

Regards,

Patrik.

Patrik_Lundblad
Employee
Employee

And here is a video of what I did. 

Regards,

Patrik.

mfarsln
Creator II
Creator II
Author

Thank you so much!

Sa_Rah
Contributor III
Contributor III

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