Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Pivot Table

Hi Community,

How to set Alternate colors in Pivot table and

how many dimension possible in pivot table

Thanks....

4 Replies
er_mohit
Master II
Master II

dimension + expression = 15 maximum upto 15 field you can add but your linkage should be fine otherwise it gives you error object out of memory and allocated memory exceed

for alternate color write this code either in dimension or expresion side click on + icon you cee the background color write this code

If(Even(RowNo(TOTAL)), RGB(255,0,0),rgb(12,231,255))

qv_testing
Specialist II
Specialist II
Author

Hi Mohit,

is it possible any column level..

qv_testing
Specialist II
Specialist II
Author

Hi Mohit,

i have requirement, they are asking 50 dimensions in PIVOT table

is it possible or not?

Thanks..

tresesco
MVP
MVP

There is no such documented limitation i believe. All you have to be careful of is, the performance, because the more the number of columns in pivot table more the performance (front end) degrades, i.e, your pivot may take long time to open.