Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatesh_5990
Contributor III
Contributor III

Container Tab should change order as per filter selection

In our dashboard we are using container, in the container we are having 5 tables like following order as A,B,C,D&E and filters value using like as same as A,B,C,D&E. 

As default the container tab(tables) will be show like A,B,C,D&E

If the user selected the filter C then the container tab(tables) order should change as C,A,B,D&E.

If the user selected the filter D then the container tab(tables) order should change as D,A,B,C&D.

I hope you all understand the requirement, can you please help me on this.

 

Thanks in advance.

Labels (1)
1 Solution

Accepted Solutions
Venkatesh_5990
Contributor III
Contributor III
Author

We have fixed the issue using rank function like the below

As per the filter selection based on the count of value the container will be display

=if(len(Only({<[ABC] = {"=Rank(count({<status={'Open'}>}number))=1"}>}[ABC]) ) = 0,0,1)

Hope it might be some one helps.

View solution in original post

6 Replies
WaltShpuntoff
Employee
Employee

As far as I know, reordering tabs can only be done manually.

-ws

Venkatesh_5990
Contributor III
Contributor III
Author

We have fixed the issue using rank function like the below

As per the filter selection based on the count of value the container will be display

=if(len(Only({<[ABC] = {"=Rank(count({<status={'Open'}>}number))=1"}>}[ABC]) ) = 0,0,1)

Hope it might be some one helps.

Dbhati_66
Contributor
Contributor

HI @Venkatesh_5990 

Where exactly did you used that condition.

Venkatesh_5990
Contributor III
Contributor III
Author

In the Show Condition 

Dbhati_66
Contributor
Contributor

For me it is not changing order, it only show/hide that tab. If possible, could you please share that qvf file.

Thanks in advance.

Dbhati_66
Contributor
Contributor

Solved  it using Bookmarks - Save Layout option.

Thanks