topic Re: pivot table design in QlikView

pivot table design

mambi — Wed, 12 Feb 2014 10:02:39 GMT

hi everyone,

in the pivot table below i got a design problem ( see red circle )

i tried right click -> cell format ... but no result !

any idea on how to resolve this problem ?

Re: pivot table design

vikasmahajan — Wed, 12 Feb 2014 10:08:07 GMT

Is there any Dimension for the same ?

Can you share your sample application pls.

Vikas

Re: Re: pivot table design

mambi — Wed, 12 Feb 2014 10:26:17 GMT

here is (updated)

Re: pivot table design

er_mohit — Wed, 12 Feb 2014 11:02:23 GMT

Hii Put your cursor on column line header side here here it comes like + arrow then expand or collapse it

Re: pivot table design

mambi — Wed, 12 Feb 2014 11:23:27 GMT

thanks but your technic don't resolve this issue

my problem is the cell with dark gray background and it's borders color

Re: pivot table design

richard — Wed, 12 Feb 2014 11:32:28 GMT

You don't have a problem here. If you lable the dimensions you will see that your data is presented well. The question is: is this the most efficient way to present your data?

Re: pivot table design

mambi — Wed, 12 Feb 2014 12:06:41 GMT

yes it's the most efficient way, but if only i can change the dark dray to white

Re: pivot table design

richard — Wed, 12 Feb 2014 12:53:52 GMT

OK, then try a Style on the Style tab.

Example:

Current style = Clean

Cell background Color Transparency = 100%

Re: pivot table design

mambi — Wed, 12 Feb 2014 13:12:27 GMT

it's don't fix my problem because i want to keep the yellow header color and if i use the Clean style all colors are gone because of the transparency