topic Re: How do I create a Fast Type Change icon that works ? in QlikView

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

Thu, 11 Dec 2014 14:27:06 GMT

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

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

yduval75 — Thu, 11 Dec 2014 14:37:11 GMT

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

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

datanibbler — Thu, 11 Dec 2014 14:38:00 GMT

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

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

Thu, 11 Dec 2014 14:42:33 GMT

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

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

Thu, 11 Dec 2014 15:07:04 GMT

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 ?

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

Thu, 11 Dec 2014 15:08:46 GMT

Hi Yoann,

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

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

yduval75 — Thu, 11 Dec 2014 15:11:13 GMT

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

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

Michiel_QV_Fan — Thu, 11 Dec 2014 15:15:45 GMT

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.

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

Anonymous — Thu, 11 Dec 2014 15:22:06 GMT

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!

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

Thu, 11 Dec 2014 15:37:16 GMT

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.

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

Thu, 11 Dec 2014 15:38:14 GMT

That sounds a good solution DataNibbler except I wouldn't know where to start.
MV

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

Thu, 11 Dec 2014 15:40:47 GMT

I want to retain the container with just two objects if possible.

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

Thu, 11 Dec 2014 15:53:25 GMT

Thanks Michiel but the requirement is for a pivot table, not a straight table. I know that the sort functionality for a pivot table is rather limited which is why I'm trying to find a simple means of toggling between two similar pivot tables (except for how they are sorted). Your example applications showed straight tables which can be sorted interactively. Pivot tables can't.

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

Thu, 11 Dec 2014 15:56:19 GMT

Sounds good ! Except my QV knowledge isn't that good. A prize for the first person to give me the full instructions as to how to do this
MV

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

morganaaron — Thu, 11 Dec 2014 16:13:44 GMT

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.

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

Thu, 11 Dec 2014 16:21:58 GMT

Oh I see ! You mean an example of using Text objects as buttons. OK, I'll see how I get on. Thanks

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

Thu, 11 Dec 2014 17:29:56 GMT

Many thanks Aaron. That's worked fine. Much appreciated.

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

Thu, 11 Dec 2014 20:19:49 GMT

hi,

just click on pivot table then go to general tab on the right you'll find allowed types just checked the type which you want