How do I create a Fast Type Change icon that works ?

[#1]

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

[yduval75]

Maybe, convert your pivot table to straight table and let users to change the sort order

[datanibbler]

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

[#4]

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

[#5]

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 ?

[#6]

Hi Yoann,

I want to keep the structure of the pivot table, thanks.

[yduval75]

So, instead of use container you can use button actions and put variables in conditionnal display of your 3 objects

[Michiel_QV_Fan]

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.

[Anonymous]

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!

[#10]

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.