topic Re: Sort in QlikView

Sort

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Can we sort QVD file,i mean order by

Re: Sort

Gysbert_Wassenaar — Thu, 01 Dec 2016 06:24:19 GMT

Yes. Load the data into a temporary table. Then sort it with an order by using a resident load (don't forget to use noconcatenate). Then store the data into a qvd file.

Re: Sort

Thu, 01 Dec 2016 06:28:23 GMT

Hi Friend,

Thanks for answer ,

you mean , we have to convert qvd into table then only it possible right?

it is a interview question , can we sort QVD ?

i said , once qvd created it can't be possible .

i am I right ?

Re: Sort

Gysbert_Wassenaar — Thu, 01 Dec 2016 06:36:10 GMT

The question is unclear. One qvd file is one file. It is not possible to sort a set containing only one item. Well, perhaps is technically possible, but it's meaningless. If you have multiple qvd files then you can sort them. For example by creation date or file size.

It is possible to sort the data contained in a qvd file by first extracting that data and then sorting it. It is not possible in Qlikview and Qlik Sense to sort the data with only one load statement. Only resident loads can sort data.

Re: Sort

Thu, 01 Dec 2016 07:08:29 GMT

Hi Friend,

Could you help me on Guage Chart and set analysis , can we use set analysis in guage chart ,

if yes could you provide me the examples

Regards,

Re: Sort

pathiqvd — Thu, 01 Dec 2016 07:44:13 GMT

Hi,

we can use set analysis in any chart there is no restriction.

sum({<YEAR={$(=max(YEAR))}>}Sales)

Re: Sort

Thu, 01 Dec 2016 09:45:23 GMT

Hi Thanks,

for your Support