topic Re: Strange random sum in chart in QlikView

Strange random sum in chart

Thu, 09 Jul 2015 15:03:09 GMT

Hi guys,

My application was working normally for some time and then suddenly the strange sum appeared. IT is a sum of others rows except one. I don't have any idea why it suddenly happened. If i open a straight qvw document from server - all is ok. If i open in in production with a user - then i see that strange sum. See attached example. Does anybody have ideas where this behaviour comes from?

Re: Strange random sum in chart

swuehl — Thu, 09 Jul 2015 15:07:39 GMT

If there is a difference between opening the QVW on desktop and on server as a certain user, I would first check if section access with data reduction is applied to the QVW. Maybe the user's row level access is removing some field values that lead to this behaviour.

Can't tell more with knowing more details about your QVW and settings.

Re: Strange random sum in chart

antoniotiman — Thu, 09 Jul 2015 15:08:41 GMT

Hi Julius,

have You checked 'Hide when null values' in Dimension Tab ?

Re: Strange random sum in chart

Thu, 09 Jul 2015 15:11:07 GMT

Yes i use data reduction. But actualy it does not remove the line it adds that strange sum.

I'm checking with a user that has full access to all data on reports but seems all users are the same. In section access I am also using sheet security

Re: Strange random sum in chart

Thu, 09 Jul 2015 15:20:11 GMT

Actualy I did it right now and it removes the value but I'm calculating all the sums of that variable in a textfield and it calculates that random sum anyway:

This is how the formula looks:

=Num(Sum(LimitAts),'# ##0.00 €')

this is how the table structure where i calculate the sum looks(see attached file)

Re: Strange random sum in chart

Thu, 09 Jul 2015 15:32:02 GMT

I came with an idea when loading this table to eliminate 0 values rows in qlikview load script and i don't know if it is this but now i don't see that strange sum. Hopefully it will not come back...