Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Or simply said:
Best,
Peter
Does the book come with searchable text or soft copy?
Thanks!
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
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.