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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dia2021
Creator
Creator

Sort order in pivot table

Hi All,

How to write a where clause with specific order list for that particular field? For example 

Load * Country , State

From 'path......'

where Country = 'USA' ,'UK'

and I want a specific order of those states associated with that Country. Is this possible to get the desired result?

Labels (2)
1 Solution

Accepted Solutions
brunobertels
Master
Master

 

Hi

if you want to set a specific load order for your table  to determine the sort order , all you have to do is use the INLINE LOAD before you are loading your table fields in any other table LOAD.

So that in a crosstable object the sort order will be respected : 

 

load * inline 

[Country , State

USA , Californie

USA , Nebraska

USA, Oregon 

UK, Lancashire

UK, Kent

..... ] ; 

 

 

View solution in original post

1 Reply
brunobertels
Master
Master

 

Hi

if you want to set a specific load order for your table  to determine the sort order , all you have to do is use the INLINE LOAD before you are loading your table fields in any other table LOAD.

So that in a crosstable object the sort order will be respected : 

 

load * inline 

[Country , State

USA , Californie

USA , Nebraska

USA, Oregon 

UK, Lancashire

UK, Kent

..... ] ;