topic Re: Document in server and in client is not the same in QlikView

Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 09:00:43 GMT

Hey all,

I'm facing a weird issue with QV document:

there is a difference in a column sort if I open a certain QV document in server or in client.

In server the column is in a descending order, while when opening the exact same document in client - this column is sorted in an ascending way, while all rest of the data is the same.

What can cause this issue?

How to fix it?

Thanks!

P.S. The sort problem is not with a specific column, it's actually with the whole document sorting...

Re: Document in server and in client is not the same

alexandros17 — Thu, 27 Feb 2014 09:24:29 GMT

Probably document in server (you access it with access point?) is not correctly published, if no, another idea could be the settings of browser (or server) and your local computer that sort fields (Dates for example) in different ways

Re: Document in server and in client is not the same

gopalopsharma — Thu, 27 Feb 2014 09:27:13 GMT

Hello Linoy,

This is a bug with sorting in Qlikview. The sort order changes in the access point.

The column which you are mentioning, is it a dimension or expression?

Default Sorting on expression does not work properly on access point.

To be on safer side we can check "Interactive Sort" box.

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 09:30:00 GMT

Hi Gopal,

the column is an expression, and interactive sort is checked...

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 09:44:18 GMT

Does this problem persist with other users too from client

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 09:45:38 GMT

It's not access point, it's LAN.

Where I see local sort settings?

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 09:46:25 GMT

All clients don't see it right

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 09:54:45 GMT

Share your file then

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 10:11:42 GMT

Guys, where I see server and client SORTING configurations?
Am I supposed to look in control panel? windows? explorer? excel?

PLS HELP!

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 10:14:09 GMT

Linoy Share your file!

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 10:20:51 GMT

Hey Aamir,

I'm pretty sure there's no need in sharing QV file cause in QV server I see everything in a right way.

I assume the problem is not with QV, but with different sort settings in client and in server, and i'm trying to figure out here where i see this configuration and change it...

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 10:26:58 GMT

I may be wrong but there is not any sort setting for server and client. I hope you have published it by access point

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 10:31:37 GMT

Have you tried Document properties -> sort and see if it is the same as the chart?

Besides that you cannot sort an object in the server client

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 12:34:56 GMT

Thomas,

the thing is that I'm opening the exact same document (.qvw file), once from a server - and the sort is descending (as it's defined in the chart properties), and once from the client - and the sort is ascending...

If the sort options were different in chart and in Document properties-->sort, then I would see it wrong when opening from the server, but it's right...

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 12:50:20 GMT

Are you sure there are no General QV settings when installing QV?

And it's not published in access point, it's LAN. There is client installation through which clients can open the file from Share folder.

Re: Document in server and in client is not the same

stevedark — Thu, 27 Feb 2014 12:55:26 GMT

Hi Linoy,

Things like sort orders are persisted on a user by user basis by access point (they get written to the .shared file on the server). If you click on View Details and Remove Last Document State before opening the document do you then get the same sort order as you saved the document with?

The sort properties are on the Sort tab of the properties of the chart or table you are looking at.

Steve

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 13:04:05 GMT

Hi Steve,

where do I click on View Details?

Do you mean to right-click on the file --> Properties --> Details? I see at the bottom of the page "Remove Properties and Personal Information". Do you mean I should click on it?

Re: Document in server and in client is not the same

stevedark — Thu, 27 Feb 2014 13:26:23 GMT

Hi Linoy,

This is in Acccess Point. You get the thumbnail (if you are in thumbnail view) and then under that the FileName, then the Date and under all of that a link stating 'View Details'. On clicking this you should see the Remove Last Document State button:

If you are in list view you need to click the + next to the document name and the Remove Last Document State button is over to the right.

Steve

Re: Document in server and in client is not the same

linoyel — Thu, 27 Feb 2014 13:29:53 GMT

The problem is that we don't use access point...

I asked the system person of the company, and he told we use LAN...

Maybe I miss something?

Re: Document in server and in client is not the same

Thu, 27 Feb 2014 13:35:29 GMT

If you dont use the accesspoint how does your uses then connects to your documents?