topic Re: Data mismatch between desktop and access point in QlikView

Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 04:57:19 GMT

I see a strange issue of data mismatch between desktop and access point.

Also i observe that it is happening only on specific scenario.

Scenario: My condition is if % is < 85 %, we need to count how many times it occured

Note: % here is a calculated column. Chg. and Base are coming from source data.

Scenario1:

Period	Chg.	Base	%	Condition
2016010	32.5	168	0.193452	Yes
2016011	77	184	0.418478	Yes
2016012	42.5	176	0.241477	Yes
2017001	19	168	0.113095	Yes
2017002	103.5	176	0.588068	Yes
2017003	60.5	176	0.34375	Yes
2017004	76	176	0.431818	Yes
2017005	59.5	160	0.371875	Yes
2017006	100	184	0.543478	Yes
2017007	119.5	160	0.746875	Yes
2017008	118	184	0.641304	Yes
2017009	75.5	176	0.428977	Yes

In this scenario, all periods are under 85 %, hence it is displaying 12 both in desktop and access point

Scenario 2:

Here is i see the problem

Period	Chg.	Base	%	Condition
2016010	232	168	138.1	No
2016011	112	184	60.9	Yes
2016012	192	176	109.1	No
2017001	104	168	61.9	Yes
2017002	32	176	18.2	Yes
2017003	0	176	0	Yes
2017004	112	176	63.6	Yes
2017005	152	160	95	No
2017006	168	184	91.3	No
2017007	136	160	85	No
2017008	112	184	60.9	Yes
2017009	152	176	86.4	No

For period 2017007, % is 85.

Wherever we have the exact threshold i'm getting mismatch

Here is my expression

if(sum(if(Aggr(Alt((sum(Chg))/sum(Base),0),[Employee ID])<0.85,1,0))=1,

sum(if(Aggr(Alt((sum(Chg))/sum(Base),0),[Employee ID],Fiscal_Month)<0.85,1,0)),0)

With this i expect Count to be 6 (Based on Condition=Yes). It is coming as 6 in desktop and 7 in access point. I suspect it is picking 2017007 which has exact 85 %

However i'm getting the right result in desktop and in access point it is incorrect.

Please help

Thanks

Satish

Re: Data mismatch between desktop and access point

tresB — Fri, 28 Jul 2017 05:09:29 GMT

Check if you have section access in the server environment. That could potentially cause the issue.

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 11:11:26 GMT

Yes i have section access enabled.

For my requirement i need section access enabled.

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 11:23:53 GMT

I also tried by unchecking section access in QMC. It's still the same...

Thanks

Satish

Re: Data mismatch between desktop and access point

tresB — Fri, 28 Jul 2017 11:28:10 GMT

Did you reload the qv app after commenting the section access section? If not try so and then check.

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 11:38:44 GMT

Here is what i have done

1. Uncomment SECTION ACCESS in script

2. Uncheck Section Access in document properties

3. Uncheck Section Access in QMC for this task

4. Reload with fresh data

Still no luck

Re: Data mismatch between desktop and access point

arvind_patil — Fri, 28 Jul 2017 11:45:57 GMT

HI Satish,

Try to publish a correct app on a temporary basis on the access point and give access to yourself and check.

may be it will give you an idea.

Thanks,

Arvind Patil

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 11:59:07 GMT

I tried this option as well and still no luck

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 12:22:07 GMT

Any other response would be of great help...

Re: Data mismatch between desktop and access point

Fri, 28 Jul 2017 12:32:29 GMT

After data refresh, open the app on the desktop client and check the data. Are you using same DB tables or QVD between two instances?

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 12:45:17 GMT

Yes. Using the same.

After data refresh i'm seeing this in DESKTOP vs Access Point

Re: Data mismatch between desktop and access point

satishkurra — Fri, 28 Jul 2017 13:48:23 GMT

This is fixed by setting the threshold limit to 0.8499 instead of 0.85 (Desktop and access point matches)