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

Announcements
Join us in NYC Sept 4th 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