
Re: Total Percentages
Sunny Talwar Oct 7, 2015 2:08 PM (in response to Robert Fishel)It would depend on the expression you are using. Can you share your expression?

Re: Total Percentages
Robert Fishel Oct 7, 2015 2:36 PM (in response to Sunny Talwar )Thank you for the reply. My expression is basically
(COUNT(Today.IDNumber)COUNT(Yesterday.IDNumber))/COUNT(Yesterday.IDNumber)


Re: Total Percentages
Manish Kachhia Oct 7, 2015 2:14 PM (in response to Robert Fishel)In actual, it could be 0.000005% also and because you are showing only one decimal it is shown as 0.0%

Re: Total Percentages
Henric Cronström Oct 7, 2015 2:26 PM (in response to Robert Fishel)By default, QlikView does not sum the values of the lines. And it shouldn't either.
Instead, it calculates the expression over the entire data set. This makes a great difference when calculating ratios, as you do here. Let's say that you want to calculate
Sum( A ) / Sum( B )
and format this as a percentage. Then the most logical thing to do on the "Totals" line, is to calculate the same ratio but for the entire scope. Summing a number of percentages usually does not make sense.
That the total here is 0.0% does not need to strange. It could be that it is 0% for almost all data, and the numbers, e.g. 36.5%, could represent a very small fraction of the entire scope.
HIC

Re: Total Percentages
Robert Fishel Oct 7, 2015 2:37 PM (in response to Henric Cronström )Thank you Henric. That makes sense

Re: Total Percentages
Robert Fishel Oct 7, 2015 2:39 PM (in response to Henric Cronström )I am trying to replicate this in Excel. Any thoughts? Is it even possible in Excel?



Re: Total Percentages
Robert Fishel Oct 7, 2015 3:19 PM (in response to Henric Cronström )After reading and rereading your comments, I decided to apply the same formula
Count % (Daily) = Today (Count)  Yesterday (Count) / Yesterday (Count)
to the totals row instead of simply summing, as you suggested. It works. Thank you
