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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help with loading excel file

I am a newbie in Qlikview.Need help on 2 things.

1) When I am loading an excel file from the script, the order of the fields get sorted alphabetically automatically.

How do I retain the order as in the excel?

2) Also, my input file has 2 rows headers. How do I keep the headers from 2 rows?

2 Replies
Not applicable
Author

go to propperties of object(that is table) then clik on sort tab, then check on load order.

see image

er_mohit
Master II
Master II

hi try to sort it as original in your chart or object by right clicking on it and go to properties-->sort tab then

there it automatically ascending check uncheck that and doing checked on load original as i attavhed image see that