Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

Re: Show pivot tables on demand

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.

cheers,

Oleg Troyansky

Re: Show pivot tables on demand

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

Best,

Peter

Not applicable

Re: Show pivot tables on demand

Does the book come with searchable text or soft copy?

Thanks!

MVP & Luminary
MVP & Luminary

Re: Show pivot tables on demand

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!

Oleg

MVP & Luminary
MVP & Luminary

Re: Show pivot tables on demand

Hi,

Load all Pivot table names in  inline table like below

PivotTables:

LOAD

*

INLINE [

PivotTableName

Pivot1

Pivot2

Pivot3];


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.


Regards,

jagan.