topic Re: Show pivot tables on demand in QlikView

Show pivot tables on demand

Wed, 27 Jan 2016 19:41:17 GMT

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.

Re: Show pivot tables on demand

Oleg_Troyansky — Wed, 27 Jan 2016 20:02:46 GMT

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

Peter_Cammaert — Wed, 27 Jan 2016 23:20:06 GMT

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

Re: Show pivot tables on demand

Thu, 28 Jan 2016 20:43:14 GMT

Does the book come with searchable text or soft copy?

Thanks!

Re: Show pivot tables on demand

Oleg_Troyansky — Fri, 29 Jan 2016 01:15:09 GMT

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

Re: Show pivot tables on demand

jagan — Fri, 29 Jan 2016 02:00:31 GMT

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.