topic Re: Bold expression in Pivot not working for 1 department in QlikView

Bold expression in Pivot not working for 1 department

rei92821 — Sat, 16 Nov 2024 18:28:55 GMT

Hello - I have a simple pivot table which pulls department and accounts. I used bold expression in the text format so the Dpt# and Dpt desc columns are in bold. It's working for all departments except for 6405, which only has amount in 1 GL account. I tried different styles in the Option but none of them would bold this department. Could you please help me find a way to bold this like all others? Thank you.

Re: Bold expression in Pivot not working for 1 department

vamsee — Wed, 17 Jun 2020 13:29:52 GMT

It should typically work.

As a workaround, you can try

http://www.qlikfix.com/2010/11/25/custom-formatting-table-cells/#:~:text=To%20enable%20this%20option%2C%20go,both%20dimension%20and%20expression%20cells.

Re: Bold expression in Pivot not working for 1 department

rei92821 — Wed, 17 Jun 2020 20:20:26 GMT

Thanks for the link, but I don't seem to have that option. The options I have in my chart are below.

Re: Bold expression in Pivot not working for 1 department

Brett_Bleess — Thu, 02 Jul 2020 13:36:09 GMT

You appear to be working in WebView mode, try taking the Desktop Client out of WebView and check properties again, it could be that things are not in the WebView mode for some reason on this one, only thing of which I can think. If you are creating server objects via the QVServer, then you will not be able to get to what I mentioned above. I did just realize the setting may be under the 'More..." button in the lower right there, did you try clicking that to see if it comes up then?

Regards,
Brett