More likely the data in your aggregation is different when you run the app on server side. Are you perhaps using Section Access causing a reduction on server?
For troubleshooting start by validating that each component in your expression returns the values that you expect.
Concatenate the Aggr() result to confirm the result are as expected; Concat(Aggr((Sum(charge)/Count(DISTINCT TicketNumber)),Resource),',')
Thank you for your suggestion to use concat. Following is the result.
Left side 2 text boxes have my original Fractile function. Right side box has the Concat function as you mentioned.
When opened in Qlikview Desktop V12:
How published version looks like in Qlikview server 12. (Opened in Google chrome)
Seems like a issue in Aggr() function. But both of these files has the same data set.
There's no section access on this document.
Troubleshooting of Aggr() is done by setting up a straight table to mimic the aggregation. In your case it would be as below.
Expression: Sum(Charge)/Count(DISTINCT TicketNumber)
With two components in the expression, you might need to split the expression into two.
Expression2: Count(DISTINCT TicketNumber)
Thank you Toni,
I did the trouble shooting like that and identified that it's a issue with Aggr() .
As per the previous trouble shoot
did not work on the server published version.
So I aggregated the numerator and denominator separately with concat()..
And it works
In Qlikview server 12 (published version)
So the solution:
Aggr(Sum(charge),Resource) / Aggr(Count(DISTINCT TicketNumber),Resource) works fine in the Qlikvew server 12 published dashboard, but Aggr((Sum(charge)/Count(DISTINCT TicketNumber)),Resource) does not work.