Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
This is fixed by setting the threshold limit to 0.8499 instead of 0.85 (Desktop and access point matches)
Check if you have section access in the server environment. That could potentially cause the issue.
Yes i have section access enabled.
For my requirement i need section access enabled.
Hi
I also tried by unchecking section access in QMC. It's still the same...
Thanks
Satish
Did you reload the qv app after commenting the section access section? If not try so and then check.
Hi
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
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
Hi
I tried this option as well and still no luck
Any other response would be of great help...
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?