Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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)))

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

plu
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

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

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

mfarsln
Creator II
Creator II
Author

Thank you so much!
plu
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

plu
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

plu
Employee
Employee

And here is a video of what I did. 

Regards,

Patrik.

mfarsln
Creator II
Creator II
Author

Thank you so much!