topic Re: Bold cell in QlikView

Bold cell

Wed, 14 Sep 2011 09:52:37 GMT

Hello everybody.

I want to bold colom in my pivot table but I'm not arrive to do.

I explain in my join document what i want exactly.

Can you help me to have this results?

Thank you for your help...

Re: Bold cell

its_anandrjs — Wed, 14 Sep 2011 10:00:40 GMT

Hi,

Use capitalize ( ) function.

Regards

Anand

Re: Bold cell

its_anandrjs — Wed, 14 Sep 2011 10:04:53 GMT

Hi,

Ok you want to bold the column so for this go to

Properties -> Style -> Select Basic and apply setting.

HTH

Rgds

Anand

Bold cell

Wed, 14 Sep 2011 10:19:44 GMT

Hi Anand,

Thank you for your help but its not what I want! I'm sorry

I dont have the good results with your indication...

Other idea??

Bold cell

SunilChauhan — Wed, 14 Sep 2011 10:22:35 GMT

in expression-> click on + sign which before expression name

go to text format and type ='<B>'

or you can try this

properties-> visual Qubes->select column or filed and check on bold which is on bottom

Bold cell

kaushiknsolanki — Wed, 14 Sep 2011 10:27:49 GMT

Hi,

Do this changes first.

Go to Settings -> User preference -> Design -> Check "Always Show Design Menu Item"

Click OK.

Go to the Chart Right Click on Cell... You will find the Option Named. "Custom Format Cell"

Change the settings as per your need.

Regards,

Kaushik Solanki

Bold cell

Wed, 14 Sep 2011 12:16:56 GMT

Hi,

I tried all your proposition but any give me the good results...

Any idea???

thank you...

Bold cell

SunilChauhan — Wed, 14 Sep 2011 12:24:00 GMT

sample file

Bold cell

Wed, 14 Sep 2011 12:51:34 GMT

See my first message for Excel file or this image...

Bold cell

Wed, 14 Sep 2011 13:28:49 GMT

I don't kow if it is possible to do this in one single chart, I doubt it, but If it is impossible to do this, I have a solution / work around that will work: You can create 4 charts (one chart for each week) and put them next to each other, and use layers (so that the dimension column is hidden behind the top layer) -> you will get a similar result, after some hard work... Regards, Robert

Re: Bold cell

its_anandrjs — Wed, 14 Sep 2011 14:08:46 GMT

Hi,

If you use the text objects as transperancey will it work for you please see the attached sample file. If the pivot table is used for reading purpose only then it is ok,

Or confirm will it ok if you use like that because there is no way i think in my knowledge.

But when data changes you need to reset it.

It is not good way but it works.

HTH

Regards

Anand

Bold cell

Wed, 14 Sep 2011 14:30:03 GMT

Hi,

my pivot table is dynamic ..is not possible for me to do what you preconize me Anand...

But I really thank you for your help...

Bold cell

Wed, 14 Sep 2011 21:40:16 GMT

May be you can create dummy expressions with a space and make their background color or Text Color as Blackas black