topic Re: Help with loading excel file in QlikView

Help with loading excel file

Wed, 15 May 2013 08:39:14 GMT

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?

Wed, 15 May 2013 08:47:55 GMT

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

see image

er_mohit — Wed, 15 May 2013 08:49:38 GMT

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