Discussion board where members can get started with QlikView.
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.
Or simply said:
Does the book come with searchable text or soft copy?
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!
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.