topic How to change a specific cell's font in a table? in QlikView

How to change a specific cell's font in a table?

Wed, 25 Nov 2020 16:16:04 GMT

I have make a table and I want to decrease the font in two specific cells. But I can only change the font for the whole Dimension. Anyone knows how to deal with that?

Thanks a lot!

Re: How to change a specific cell's font in a table?

Chanty4u — Mon, 11 Apr 2016 10:52:26 GMT

As far as I know its not possible to change the only cell font size.

Re: How to change a specific cell's font in a table?

engishfaque — Mon, 11 Apr 2016 10:55:31 GMT

Dear Shawn,

Here is the way,

Enable your Grid View (CTRL + G) > Right Click on your Cell where your want to change your font size > Custom Format Cell > Text Settings > change your font size > Apply > OK.

Kindly check attached screenshots for clear understanding.

--------

-------

Kind regards,

Ishfaque Ahmed

Re: How to change a specific cell's font in a table?

Chanty4u — Mon, 11 Apr 2016 11:01:09 GMT

I think it will not work for Perticular cell. ...if u apply that it will allows for entire row/column.

If i am wrong please correct me.

Re: How to change a specific cell's font in a table?

engishfaque — Mon, 11 Apr 2016 11:09:06 GMT

Dear Chanty,

It works for one cell such as other "Custom Format Cell option" work.

Kindly find attached screenshot for output,

Kind regards,

Ishfaque Ahmed

Re: How to change a specific cell's font in a table?

Chanty4u — Mon, 11 Apr 2016 11:13:16 GMT

hmmm. i have alrdy chkd that thats y i asked u bro.

chk it fr me

Re: How to change a specific cell's font in a table?

Chanty4u — Mon, 11 Apr 2016 11:16:17 GMT

Hi Bro,

Can u share a sample app ...with diffrnt font size in cells.

for me its nt working.

Re: How to change a specific cell's font in a table?

Tue, 12 Apr 2016 01:24:06 GMT

Hi Guys,

Thanks a lot for your help. However I just do then same way but get the same result as Chanty.

Ishfaque , Would you mind sharing more detail about the process in second screen?

Re: How to change a specific cell's font in a table?

Chanty4u — Tue, 12 Apr 2016 11:31:47 GMT

Hi,

by using custom format cell..

u can change the Font and colour of the Cells and Dimensions . text colur lik so on..... lik u can see more options in that screen .

Re: How to change a specific cell's font in a table?

Wed, 13 Apr 2016 01:08:08 GMT

Yep, I did it but cannot change specific one cell. In the From " Apple Change to", only can choose Dimension or Expression. So the change cannt be only one cell. I just wonder how he can do that?

Re: How to change a specific cell's font in a table?

Chanty4u — Wed, 13 Apr 2016 08:27:05 GMT

Even i cant able to do that...

Re: How to change a specific cell's font in a table?

Anonymous — Wed, 13 Apr 2016 09:01:28 GMT

Hi, Shawn,

I support Chanty, he is correct, you can not change the font SIZE of a specific cell.

But if your specific one cell is in the "total" row of the straight/pivot table. Then it works. I think that is why we see it in Ishfaque's reply.

But you can change the font color, background and format of a specific cell, by given the cell a conditional expression like below, this works for both dimensions and expressions.

Re: How to change a specific cell's font in a table?

Fri, 15 Apr 2016 01:15:43 GMT

Hi Zhihong

Thank you so much! I tried the method you provide. However, I just wonder how to change fornt in the text format with the code. Is there any code to control the font?

Re: How to change a specific cell's font in a table?

Anonymous — Thu, 28 Apr 2016 08:48:09 GMT

Hi, Shawn,

Sorry for late reply. No, as I know, you can not conrol font in Qlikview for a specific cell, it will always be the font you select in the font tab. But you can change the format, like use italics/underline/bold, corresponding with <i>,<u>, <b> in the conditional expression.

Hope this helps.

Zhihong