Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

martin_hamilton
Contributor

calculate percentages - am stuck!

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:

straightable.PNG

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

excelexamples.PNG

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

1 Solution

Accepted Solutions

Re: calculate percentages - am stuck!

Try this

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

View solution in original post

2 Replies

Re: calculate percentages - am stuck!

Try this

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

View solution in original post

martin_hamilton
Contributor

Re: calculate percentages - am stuck!

Thanks Sunny! I knew it was something simple!