How do I apply text attributes to column headings in a QlikView pivot table ?

Posted on 2014-08-14
Last Modified: 2014-08-14

I have a pivot table object in a QlikView dashboard but am struggling to find the tab option to change the text attributes of column headings. The headings are for two expression columns which I wish to make bold.

However, the Font tab, under Font Style, has a value of 'Set by Style' which I don't appear to be able to change.

Any ideas ?

Question by:Tocogroup
    LVL 42

    Expert Comment

    by:Rob Jurd, EE MVE
    There's a bit of mucking around to get this one to work.  You have to either allow advanced layout settings or clear the style for the table.  I'm trying to remember!..  I've fired up Qlikview so I'll take a look and let you know.
    LVL 42

    Accepted Solution

    sorry, I've read this wrong.  To bold the heading, right click on the heading on the desktop view and choose "Custom Format Cell".  If you don't see this then you need to enable it:
    Then you'll see this when you click "Custom Format Cell"

    Author Closing Comment

    Not QV's most intuitive feature.
    Thanks again
    LVL 42

    Expert Comment

    by:Rob Jurd, EE MVE
    No definitely not. You know how long it took for me to find that the first time? I'm sure it was days....
    I know you can also use codes in expression strings like "=<b> my heading name</b>". I just couldn't remember if it was square it angle brackets.
    Yes there's a lot to be desired about their interface. Just out of curiosity, what version are you running?

    Author Comment

    11.00.11149.0 IR to be exact
    Yes, they look like HTML tags

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Let’s list some of the technologies that enable smooth teleworking. 
    In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
    Video by: Tony
    This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now