Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading columns in Pivot in "Load order"

I have a raw data with nearly 100 columns

When i do a normal load in Qlikview, and insert pivot , the field list appears in Alphabetical order

Its manually impossible to insert the columns one by one in the original order , esp when there are 100+ fields

in Excel, pivot table shows the list of fields in the original order .. but not in Qlikview

Any simple tricks to fix this ?

Thanks

6 Replies
MK_QSL
MVP
MVP

What is the name of your columns?

You can also create something like below..

Create an inline table

Sorting:

Load * Inline

[

     SortingID, ColumnName

     1, Column1

     2, Column2

     3, Column3

];

Now go to Pivot table and sort by expression ascending or descending order

type =SortingID in expression

UPDATE:

Please check enclosed file for better understanding..

Not applicable
Author

Hi Thanks for your reply..

Example of data

Geography, Region, Sub Region, Account Name, Account ID, Opportunity Name, Opportunity Value etc.. and100 other columns

I have nearly 600,000 records for these

Do you think inline load is feasible?

Thanks

Not applicable
Author

Plus i dont want to sort the raw data as per expression.. Doesnt matter to me

I want to keep the "original order" of columns in the pivot ( as per load order)

MK_QSL
MVP
MVP

You can either use Inline Load or create an Excel Table with Dimension and your desired SortingOrderID.

Second option is to write an expression with Match function but it is not feasible looking upon no of dimensions you have.

veidlburkhard
Creator III
Creator III

Hi Karthik,

this seems not to be possible for pivot tables in QlikView, where as for the table box it is a standard feature:

in the 'General' tab with one click you can have the choice of load order of fields

TestLoadOrder.jpg

Hope this helps.

Burkhard

TigerisBack
Champion
Champion

Hi till there is no expression in your pivot table

you can use table box available in qlikview.

and using load order as in 

post above.

but if you have any expression intable then you need to do it mannually either in straight or pivot table.

so its depends on need .

hope this helps