topic Re: Pivot Table in QlikView

Pivot Table

Nagaraju_KCS — Wed, 18 Sep 2013 05:44:26 GMT

Hi Community,

How to set Alternate colors in Pivot table and

how many dimension possible in pivot table

Thanks....

Re: Pivot Table

er_mohit — Wed, 18 Sep 2013 06:06:17 GMT

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

Re: Pivot Table

Nagaraju_KCS — Wed, 18 Sep 2013 06:44:28 GMT

Hi Mohit,

is it possible any column level..

Re: Pivot Table

Nagaraju_KCS — Wed, 18 Sep 2013 06:54:54 GMT

Hi Mohit,

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

is it possible or not?

Thanks..

Re: Pivot Table

tresB — Wed, 18 Sep 2013 06:59:45 GMT

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.