topic Re: Year missing in access point in QlikView

Year missing in access point

alis2063 — Thu, 12 Oct 2017 18:56:52 GMT

Hi Guys,

Something strange that year(2018) is missing from Access point where as it is reflecting in Desktop Application.

In Access Point

Its showing year as below

2014/2015/2016/2017

In the Desktop

It is 2014/2015/2016/2017 /2018

Please let us know what could be possibilities.

Re: Year missing in access point

vishsaggi — Thu, 12 Oct 2017 19:12:15 GMT

Is this displayed in your listbox? In your desktop switch to Web View mode and see if it is hiding? Increase your listbox size.

Re: Year missing in access point

Anil_Babu_Samineni — Fri, 13 Oct 2017 03:11:48 GMT

Would you like to ask few questions

1) Are you sure about restriction data in script like Where condition involved

2) And, Are you accessing the same file where desktop showing correct values

3) I never come up with this issue earlier.

Re: Year missing in access point

avinashelite — Fri, 13 Oct 2017 05:49:42 GMT

have you refreshed the data from server ?? if the qvd's are different them their is a change for this miss match ..

check for any trigger set also

Re: Year missing in access point

alis2063 — Fri, 13 Oct 2017 17:34:38 GMT

Hi Vish,

In web view ,it is reflecting.

Also checked with increase the size of list box.

Re: Year missing in access point

alis2063 — Fri, 13 Oct 2017 17:38:18 GMT

Hi Anil,

the answer is below question,

1) Are you sure about restriction data in script like Where condition involved-none of condition applied.

2) And, Are you accessing the same file where desktop showing correct values-Yes i have picked the same production file which is appeared in access point

Re: Year missing in access point

alis2063 — Fri, 13 Oct 2017 17:40:35 GMT

Hi Avinash,

Using the same qvd in Desktop app.

Re: Year missing in access point

pradosh_thakur — Fri, 13 Oct 2017 18:13:39 GMT

Do you have section access in your document?

Re: Year missing in access point

vishsaggi — Fri, 13 Oct 2017 18:57:51 GMT

Can you share your sample by masking the fields using scrambling technique and upload here. Will loo at our end. And can you send the screen shot of your Year field from Access point.

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling

Re: Year missing in access point

alis2063 — Fri, 13 Oct 2017 19:48:02 GMT

No we don' t have ,Its internal app .

Re: Year missing in access point

vishsaggi — Fri, 13 Oct 2017 20:10:36 GMT

IF you can send me your desktop version of your document i can try at my end.

Re: Year missing in access point

Anil_Babu_Samineni — Sat, 14 Oct 2017 02:45:02 GMT

I believe you are doing first point, This will happen like this? But, When you say In access point it is not correct values that is i am thinking. Can you provide three images.

1) Enterprise Image Year

2) Server Image Year

3) Path Correct

Re: Year missing in access point

alis2063 — Sun, 15 Oct 2017 09:06:11 GMT

version 11.20 SR12 64 BIT