Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Can we sort QVD file,i mean order by
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.
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 ?
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.
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,
Hi,
we can use set analysis in any chart there is no restriction.
sum({<YEAR={$(=max(YEAR))}>}Sales)
like
Hi Thanks,
for your Support