topic Re: Change Table cell Heading format in QlikView

Change Table cell Heading format

kushalthakral — Sat, 26 Apr 2014 07:56:30 GMT

Dear All

I have a table like below

Model	Sales	Target	Commission
A	10	10	11
B	19	15	12
C	20	25	13

and i actually want to make Sales and Commission Heading Bold not all

is there any way i can achieve it in qlikview

Thanks

Kushal

Re: Change Table cell Heading format

MK_QSL — Sat, 26 Apr 2014 08:01:10 GMT

Haven't seen any option as per your requirements... But may be someone can suggest an alternate option...

Re: Change Table cell Heading format

SunilChauhan — Sat, 26 Apr 2014 08:57:23 GMT

see the attched file

hope this helps

Re: Change Table cell Heading format

MK_QSL — Sat, 26 Apr 2014 09:05:56 GMT

Sunil, Good effort...Appreciate !!!

But here Sales, Target and Commissions are three different Expressions and if out of three only one or two need to be kept as BOLD.

Re: Change Table cell Heading format

SunilChauhan — Sat, 26 Apr 2014 09:17:59 GMT

hi manish

you can do that also only you need to move target from dimesion to Exression

it will then also.

Try that for me

hope this helps

Re: Change Table cell Heading format

MK_QSL — Sat, 26 Apr 2014 09:48:24 GMT

Have you used Customer Cell Format?

Re: Change Table cell Heading format

SunilChauhan — Sat, 26 Apr 2014 09:52:50 GMT

Yes custom cell format

then visual Cube also

Re: Change Table cell Heading format

MK_QSL — Sat, 26 Apr 2014 09:59:54 GMT

OHhhh.. got it... It was not working on my apps. But later I found that you have used Pivot Table and I was implementing the same in Straight Chart...

May be I could be wrong... Let me know, is it possible to make 2 out of 3 expressions header BOLD in straight table...

Re: Change Table cell Heading format

its_anandrjs — Sat, 26 Apr 2014 10:34:54 GMT

Hi Kushal,

You can set the Heading in bold but using the Custom Properties as other member suggest like from

Settings >> User Preference >> Design >> check mark the option Always Show Design Menu Items and visual cues option as bold See the snap but not a good trick.

But another approach is using the text object for Sales and Commission and make it Bold and from its properties >> Layout Top for Sales and Commission text objects and chart layout properties make bottom and make all object not movable will look like attached sample which is straight table may be it is a trick you can use it for the pivot also.

Re: Change Table cell Heading format

kushalthakral — Sat, 26 Apr 2014 11:01:01 GMT

hi anand

can you please share the qvd

thanks

Kushal