Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Frédéricdh
Creator II
Creator II

Pivot table and List Box

I have a Pivot table and a ListBox which are linked with the dimension Week.

 

When I choose a week in the Listbox, I don't want that the pivot table change , I want that the pivot table show all the value, alle the week.

 How i do this?

 

thanks in advance.

Labels (1)
3 Replies
anat
Master
Master

You can bypass week field in set analysis. 

Sum({<week= >}Field)

Frédéricdh
Creator II
Creator II
Author

Thank you, it works, but in the Pivottable, I have 2 dimensions, the week and the facility. Andfor the facility I sort i with a function but now when I click a week in the list box, the order change and it doesn't follow the sort function I give.

 

Why?

Frédéricdh
Creator II
Creator II
Author

My sort function works with Match(Facility, 'A', 'B', 'C')