QlikTip #34: Some hints on working with the QlikView Designer (Part 1 – QlikView Designer)

A colleague asked me today to promote the two blog-posts where the QV10 feature of moving objects while pressing the ALT-key is explained (see qlikboard.com and guerillabi.com).

I thought instead of just posting these two links I could deliver more value by starting a series of articles which cover most of the tipps & hints when working with the QlikView Designer. (Sure, if you are a QlikView addict this will not really tell you something new, but maybe this series of articles is a good starting point for QlikView Beginners …)

So this series of articles cover the following topics:

Using the design mode of QlikView

First of all it is important to mention that there is a special design mode in QlikView!

You can activate this by activating the “Design Grid” (Menu “View” => “Design Grid” or by using the shortcut Ctrl + G or using the icon for changing to the design grid: ).

Doing so, you will then see the design grid (layout raster), which may help you to align objects:

The Design Grid in QlikView

For further information how to change the layout raster, please have a look at the following article: QlikTip #14: Changing the Layout Raster.
Having the Design Grid enabled now, you do not just have a layout raster available to align your objects, furthermore you’ll also see which objects are selected, which is really usefull when you are resizing, moving your objects:

Selected Objects in Design Grid Mode

You can select one or more objects by

  • Clicking on the object or better clicking on the title bar …
  • Holding Shift + Clicking on the desired objects to select multiple objects
  • Pressing the left mouse-button and create a selection square form bottom-right to top-left (only those objects which are per 100% within the selection will be selected):

Selecting objects by creating a selection area

Last but not least it has to be mentioned that there is a very nice functionality of QlikView only available if your are in the “Design Grid” mode:

Custom Cell Formatting

As you know there are several possiblities to design rows, columns & cells in the QlikView designer, but the “Custom Formatting” functionality is probably the most convenient one:

If your are in the “Design Grid” mode and activate the context menu of a TableBox or Chart (Pivot Table or Straight Table) you’ll see an additional menu entry called ‘”Custom Format Cell”:

Calling this you’ll see a dialogue with a lot of nice and easy-to-use functionalities to format the underlaying table:

OK, that’s the first part of this series of articles, stay tuned and do not miss the other parts:)

Bookmark and Share

and tagged , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

7 Comments

  1. Brian Garland
    Posted April 29, 2011 at 21:39 | Permalink

    Well written. Thanks!

  2. Alexander Mosquera
    Posted April 29, 2011 at 22:44 | Permalink

    Wow, thanks! I did not know about the last one with custom formatting. I’ve never really had any use of the design grid layout before but now I see that I do.

    Been following your blog for a while and I like series like this.

    Oh, and another tip on the topic: Hold Ctrl+Shift for moving elements within charts (such as the diagram, the legend, the title, and so on)

    • Posted April 30, 2011 at 16:53 | Permalink

      Hi Alexander,

      thanks for comment.
      You can be sure that I will cover this shortcut (and some more) in Part 2 (Moving objects).

      Thanks for reminding me … :)

      Regards
      Stefan

      • Alexander Mosquera
        Posted April 30, 2011 at 17:18 | Permalink

        Looking forward to it :-)

  3. Rob Wunderlich
    Posted April 30, 2011 at 20:07 | Permalink

    “Custom Format Cell” can also be made available by checking”Always Show Design Menu Items” in User Settings, Design. With that option selected Custom Format is available with grid on or off.

    Nice series!

  4. Posted December 10, 2013 at 03:21 | Permalink

    I еverу time emailed thiѕ blog post page to all my associates,
    bеccause if like to read it afterward my contаcts will too.