Custom formatting table cells

By Barry Harmsen

Custom format cellA short tip today about something that actually took me quite some time to figure out: how to easily format table cells. Where in Excel you can just right-click on a cell and choose “Format Cells”, that option seems to be missing in QlikView … or is it?

Of course not! The good people at QlikTech have only hidden it very well. To enable this option, go to the “View” menu and activate the “Design Grid”. Now when you right-click on a table cell you can select the “Custom Format Cell” option, which opens a dialog window that lets you format both dimension and expression cells.

Custom format cell menu

Another way to enable this option (and the one I prefer) is by going to the User Preferences (“Settings” -> “User Preferences”) and enabling the “Always Show Design Menu Items” option on the “Design” tab. Now the “Custom Format Cell” option will always be shown.

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm a Business Intelligence Consultant at Bitmetric and based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past 10 years I have been specializing in Qlik and a more user-centric form of BI. I have done numerous QlikView and Qlik Sense implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

6 Comments

  • 1
    Wesley Bezerra
    June 3, 2014 - 22:01 | Permalink

    Very Good!
    hidden option
    thanks!

  • 2
    Nicole
    November 5, 2014 - 11:42 | Permalink

    Dear Barry,

    Thank you for explaining this possibility. Very usefull. Could you perhaps explain how you were able to save the format for the custom table cells?

    Thanks!

  • 3
    Kishore
    September 24, 2015 - 03:11 | Permalink

    How can I format a particular cell(in my case- I want cell “total “to be changed) with different expression. I don’t want it behave based on column expression.

  • 4
    zyko
    February 10, 2017 - 16:46 | Permalink

    How can someone change the RowHeight of cells?
    I saw some bug issues when changing to web-view

  • 5
    Lalitha
    June 4, 2018 - 14:27 | Permalink

    Is there a option to enable color formatting in Qliksense?

  • Leave a Reply

    Your email address will not be published. Required fields are marked *

    Read previous post:
    Prebuilt QlikView Script for Mozilla’s Open Data Visualization Contest

    A few days ago I became aware of the Mozilla Open Data Visualization Contest that is being organized by Mozilla...

    Close