Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
sacc
Contributor II
Contributor II

I need to be able to arrange the values or fields in this table in the order that I want.

I need to be able to arrange the values or fields in this table 'Partida' in the order that I want.Can you help me by providing a solution, please? its a Pivot table

sacc_0-1712841430300.png

 

Labels (4)
6 Replies
Anil_Babu_Samineni

What do you mean by in the order you want? Do you want Alphabetical (a to z)?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sacc
Contributor II
Contributor II
Author

No, I want to put the order to my liking of the subfields how that could be done

Anil_Babu_Samineni

If you want to divide/split the words, you can try with Subfield() otherwise please try to explain more in detail about outcome from the given input (Good to have one value).

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sacc
Contributor II
Contributor II
Author

lo que quiero es que tdos estos subcampos del campo tabla poder ordenalos a mi gusto osea ponerlos en el orden que yo desee eso como seria y donde seria el cambio 

sacc_0-1712844674548.pngsacc_1-1712844690286.png

 

 

Anil_Babu_Samineni

Hi, if you are not able to show the outcome, it is really difficult, The screenshot you sent is more for sorting. So, what sorting you are interested accordingly we will help you.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can load a dummy table of the values in the order you want to establish as sort order. Here is a post showing for QlikView. https://qlikviewcookbook.com/2012/11/establishing-a-sort-order/

To use Load Order as sort option in Qlik Sense uncheck both Numeric and Text options in sort. 

rwunderlich_0-1712856690727.png

 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com