topic Re: Reorder Tab in QlikView

Reorder Tab

parag_anilnaik — Tue, 15 Jul 2014 08:18:01 GMT

We have a requirement to change the index of Tab. For instance for user 1 the TAB sequence would be Orange,Green,Red. for the other user the sequence would be Red, Orange, Green. Will it be possible to implement

Re: Reorder Tab

ThornOfCrowns — Tue, 15 Jul 2014 08:52:17 GMT

I don't think so, unless someone knows how to manipulate the Qlikview.txt or TopView.xml files on the fly.

Re: Reorder Tab

sudeepkm — Tue, 15 Jul 2014 09:08:21 GMT

I don't think tabs can be re order dynamically but may be you can hide the tabs and use buttons and in that case you can create multiple sets or orders of button based on the combination of buttons.

Re: Reorder Tab

Tue, 15 Jul 2014 09:15:20 GMT

I don't know how to order tabs but you can duplicate them and give permissions by user:

Orange, Green, Red, Red, Orange, Green

The first 3 only available for user 1 and the last 3 for user 2

It's a dirty solution but it will work...

Regards!

Re: Reorder Tab

martynlloyd — Tue, 15 Jul 2014 09:35:06 GMT

Thats right Sudeep.

Parag you can set the tabs to show conditional based on a variable (say vTab='SH01'), and use button actions to set that variable. To get the desired effect you can create two sets of buttons in the required order, and condition show each set based on a variable (say UserPref='OGR'), which is set by the user id.

Ordering:

Mapping

LOAD * Inline [

User, Order

UserA, ORG

UserB, ROG

UserC, ROG

];

UserPref:

LOAD

ApplyMap('Ordering', OSUser, 'ORG') as UserPref

AutoGenerate (1)

;

let us know how you get on...

Re: Reorder Tab

martynlloyd — Tue, 15 Jul 2014 09:36:46 GMT

I prefer Sudeep's approach, because you only duplicate the buttons and not the whole tabs.

Regards.

Re: Reorder Tab

Tue, 15 Jul 2014 09:40:53 GMT

This can be possible by Sheet properties ---> Tab color ---> In calculated try to use the "osuser()".

=If "osuser()" = "A",'Green','Red'

Re: Reorder Tab

Tue, 15 Jul 2014 09:45:27 GMT

I think the color is the name of the tab not the color of the tab

Re: Reorder Tab

Tue, 15 Jul 2014 09:59:36 GMT

Please try the below

Re: Reorder Tab

parag_anilnaik — Mon, 21 Jul 2014 10:11:10 GMT

Yeah thats the same thing which were trying..There is no direct option available in Qv. Apart from that changing anything in prj files will not be liable for Qv support