Show pivot tables on demand

[#1]

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.

[Oleg_Troyansky]

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

[Peter_Cammaert]

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

[#4]

Does the book come with searchable text or soft copy?

Thanks!

[Oleg_Troyansky]

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

[jagan]

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.