topic Re: Sorting of available fields in QlikView

Sorting of available fields

Wed, 08 Aug 2012 04:20:37 GMT

Hi all,

I loaded table files (spreadsheet) to qlikview. In the spreadsheet, the fields are aranged as follows (from left to right):

Month

Level

However when I create an object e.g. tablebox in qlikview, the available fields are sorted as follows:

Level

Month

Apparently it is alphabetically.

Is there a way to make qlikview sort according to how it is arranged in the data source?

Thanks

Re: Sorting of available fields

Wed, 08 Aug 2012 05:22:36 GMT

Hi patsys50,

Simply you go to sort option & check the "Load Order" check box and choose original option from drop down box.Uncheck all other check box.

Re: Sorting of available fields

rajni_batra — Wed, 08 Aug 2012 05:25:57 GMT

Obviouly you can promote and demote the fields in any Object.

see the attachment

Re: Sorting of available fields

senpradip007 — Wed, 08 Aug 2012 05:28:08 GMT

Hi patsys50,

you can check the 'Load Order' as 'Original' and unchecked all other of other sort priorities.

Hope it will help you.

Cheers

Pradip

Re: Sorting of available fields

Wed, 08 Aug 2012 05:44:54 GMT

Hi guys,

Thank you for your replies. Unfrotunately I was not very clear on my original post so I will elaborate.

The fields that I want sorted are the ones in the AVAILABLE FIELDS list, not in the FIELDS DISPLAYED IN TABLEBOX.

Please see below:

The reason for asking about this is that in my actual data, my table file (spreadsheet) has 120 column fields arranged intuitively from left ot right. Normally the fields located to the left are the more important ones. This should help me in identifiying which fields to add to the sheet object (e.g. table box).

By default, qlikview arranges them alphabetically and it is quite confusing especially that some of the fields have similarity in the names.

Re: Sorting of available fields

rajni_batra — Wed, 08 Aug 2012 05:47:47 GMT

i have attached the screen shot did u check that???

Re: Sorting of available fields

Wed, 08 Aug 2012 05:51:42 GMT

Yes I did and like I said in my last post, I want it sorted while in the AVAILABLE FIELDS box , not when they are already in the FIELDS DISPLAYED IN TABLEBOX.

Re: Sorting of available fields

rajni_batra — Wed, 08 Aug 2012 05:53:53 GMT

Ok i dont think it would be possible.. sorry