topic Pivot table dimension in QlikView

Pivot table dimension

Tue, 14 Aug 2012 07:58:34 GMT

In my QlikView report I have pivot table with multiple dimensions, some of are pivoted on top. Is there any way to make top pivoted dimensions value as bold, for expressions am able to achieve with the "Visual Cues" option.

Thanks

Re: Pivot table dimension

its_anandrjs — Tue, 14 Aug 2012 08:29:45 GMT

I think like this is not possible, but for all values this could be done.

Thanks & Rgds

Re: Pivot table dimension

Tue, 14 Aug 2012 09:53:07 GMT

Hi Anand,

For all values means for all the dimension or specific to that dimension, please let me know the way.

Re: Pivot table dimension

giakoum — Tue, 14 Aug 2012 10:33:12 GMT

You can try to use Custom Format Cell.

Right click on the one of the top pivoted values, select Custom Format Cell and then bold from the dialog that emerges.

If Custom Format Cell is not available when you right click, enable it from User Preferences --> Design --> Always Show Design Menu Items.

Re: Pivot table dimension

its_anandrjs — Fri, 17 Aug 2012 07:48:51 GMT

Hi,

I want to say if you use visual cue and Custom Format Cell all rows should goes Bold so for that put code in expression by click on plus sign and in option Text Format write '<B>'.

Thanks Rgds