Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show pivot tables on demand

I have lots of pivot tables. I want to select which pivot table is displayed based on list of pivot table names. Is it possible to do that? I have not been able to find anything on that. Any example will help. Thanks.

5 Replies
MVP & Luminary
MVP & Luminary

Any object can be hidden or conditionally displayed using a "Show Condition" (Layout tab, of Properties).

You can formulate your condition in such a way that only some of the Pivot Tables are displayed at a time - based on a button action, or otherwise.

I'm describing this technique, among many others, in my new book QlikView Your Business.


Oleg Troyansky

Or simply said:

  • In your script, create an INLINE table with a single field that contains Pivot table names. Let's call this field PivotName. The table shouldn't associate with any other table (date island)
  • Display that field in a listbox and make sure that "Always one selected" is enabled.
  • In your different pivot tables, enable Pivot Properties->Layout->Show->Conditional and enter an expression like
    PivotName = 'NameInListBox' in the expression field



Not applicable

Does the book come with searchable text or soft copy?


MVP & Luminary
MVP & Luminary

The printed book doesn't come with a searchable text, but you can purchase an e-book in any of the commercially available formats - Kindle, iBooks, B&N, etc...

In addition, there is a huge download file with the electronic materials for the book's tutorials.

Hope you enjoy it!


MVP & Luminary
MVP & Luminary


Load all Pivot table names in  inline table like below









Now in front end try like this in

Chart Properties -> Layout -> Show -> Conditional and give below condition

For Pivot Table 1:

SubStringCount('|' & GetFieldSelections(PivotTableName, '|', 100) , '|Pivot1|')

For Pivot Table 2:

SubStringCount('|' & GetFieldSelections(PivotTableName, '|', 100) , '|Pivot2|')

For Pivot Table 3:

SubStringCount('|' & GetFieldSelections(PivotTableName, '|', 100) , '|Pivot3|')

Hope this helps you.