Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a Container object which holds a pivot table and a chart. The pivot table is sorted on Dimension 1. However, I want to create a different pivot table which sorts the data on Dimension 2. Rather than create another object within the container, I want to create a Fast Type Change icon to toggle between the two pivot tables.
What are the steps I need to follow to make this work ?
Thanks
MV
Hi Maureen,
The conditional show suggested by DataNibbler is a good option if you're not using a container - the problem with this is it relies on you placing both objects in the same place for it to look seamless - with a container it wouldn't "replace" the other object as much as just hiding one and showing the other.
I've attached an app here that shows what I mean- the text box on the right flips between 0 and 1 in a variable that is used to show/hide the same pivot table simply with a different order for the dimensions.
Maybe, convert your pivot table to straight table and let users to change the sort order
Hi Maureen,
the easiest way will probably be to just make implement both dimensions 1 and 2 in your pivot_table and make them dependent on the value of a variable (it's easiest to use a binary variable that can be 1 or -1)
=> Then you can create a button to switch the value of that variable.
HTH
Best regards,
DataNibbler
Hi Maureen,
If you just want to change the dimension but all the expressions are the same, have a look at creating a cycle group and using that as your dimension in the pivot to sort on.
click settings and then document properties, navigate to the group tab, create a new group and add the two dimensions you want to that group.
Hope that helps
Joe
Right, I'm beginning to realise that Fast Type Change is not going to be able to do what I wish, that is, toggle between two almost identical pivot tables (except for the sort).
Could I use a button in the caption to click on and replace the one pivot table with the other ?
Hi Yoann,
I want to keep the structure of the pivot table, thanks.
So, instead of use container you can use button actions and put variables in conditionnal display of your 3 objects
Maureen, check out the what's new in QlikView 11 application that is installed with QlikView 11.
Go to sheet Reports and review the tables used there.
I think that will fit your requirement completely.
that's the route i would go...instead of creating a new pivot chart though, you could try @DataNibbler 's approach. you can use a button or a text box for toggle...i prefer text boxes as i find them a little more modifiable than buttons and you can set an image as the content and doesn't have to be text....so may be you can get your fast change icon after all except it is your own creation and not the default!
It's a good idea Joe but I want both dimensions (Region and Account Number) displayed in my pivot table at the same time. Your solution only shows one at a time.