Discussion board where members can get started with Qlik Sense.
I need to sort the values of certain fields in pivot tables. Is there a way to do this in qlik sense??
For example I need to sort the field SEZIONE that has value RESTO, FURTO,INCASA, CONFIDO, TUTELA DELLE OPERE D'ARTE E D'ANTIQUARIATO, INCENDIO E RESPONSABILE CIVILE TERZI.
I need to sort the SEZIONE values as INCENDIO, FURTO, CONFIDO, RESPONSABILIE CIVILE TERZI, TUTELA DELLE OPERE D'ARTE E D'ANTIQUARIATO, INCASA and RESTO.
Is there a way to do this in a pivot table??
Sorting in a pivot table can only be done column after column. So you first set the sorting of the first column. That in that drop down, you can make the second sorting. You can't sort the pivot table based on the second or further column.
What function do I need to use to order the values of a single column? I tried the "Match" function in the "order by expression" sort but it did non work
I also tried ordering labels field this way but it's not working can someone help understanding why and how can I sort my field properly??
ORDER_TABLE:LOAD * INLINE[sezione,Ordine_sezioneINCENDIO,1FURTO,2CONFIDO,3RESPONSABILITÀ CIVILE VERSO TERZI,4TUTELA PER LE OPERE D'ARTE E D'ANTIQUARIATO,5INCASA,6RESTO,7];
and then I tried to sorting by expression with the Ordine_sezione field but it's not working
Check this example: