calculate percentages - am stuck!

martin_hamilton — Wed, 25 Nov 2020 16:16:04 GMT

Hello

maybe because its a friday but I am stuck trying to figure this out!

I have managed to build differing measures which are correct but when I try to calculate the percentage based on the measures its not providing the correct output! I have performed the logic in excel but cant get it right in the expressions i am building, i know its probably something simple but I cant figure it out. see below:

i am expecting the following values though (excel screenshot below).

My expressions are:

Utilised Days - =Sum( {$<Usage = {"Utilised"}>} Days )

Total Days Minus Holidays - =Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days )

% Utilised = =Sum( {$<Usage = {"Utilised"}>} Days )/Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days )/100

Any help much appreciated.

thanks Martin

Re: calculate percentages - am stuck!

sunny_talwar — Fri, 02 Mar 2018 12:49:50 GMT

Try this

=Sum( {$<Usage = {"Utilised"}>} Days )/ (Sum(Days)- Sum( {$<Method = {"Holiday"}>} Days ))/100

Re: calculate percentages - am stuck!

martin_hamilton — Fri, 02 Mar 2018 13:47:28 GMT

Thanks Sunny! I knew it was something simple!

topic Re: calculate percentages - am stuck! in QlikView

calculate percentages - am stuck!

Re: calculate percentages - am stuck!

Re: calculate percentages - am stuck!