topic Re: mathematical calculation in Qlik script in QlikView

mathematical calculation in Qlik script

qliklearnervir — Sun, 18 Feb 2018 06:19:09 GMT

Hi,

We have one of the requirements where our data looks like below:

and we want to calculate formula in a script itself.

% Revenue= (sum(BookingActual)/sum(Total Seats) - sum(BudgetActual)/sum(Totalbudgetrooms)) / sum(BudgetActual)/sum(Totalbudgetrooms)

please suggest the same.

mdmukramali — Sun, 18 Feb 2018 07:59:40 GMT

Hi,

if you want to Calcualte for each row % Revenue then you can use.

(([Booking Actual]/[Total Seats])-([Budget Actual]/[Total budget rooms]))/[Budget Actual]/[Total budget rooms] as Revenue.

if you have multiple rows for same ID then you have to use group by function .

let me know if you need something more.

vikraant — Mon, 19 Feb 2018 05:38:14 GMT

Hi Virendra,

You can use the formula you have mentioned , aggregating the values by ID.

Load

ID,

(sum(BookingActual)/sum(Total Seats) - sum(BudgetActual)/sum(Totalbudgetrooms)) / sum(BudgetActual)/sum(Totalbudgetrooms) as [%Revenue]

Group By ID ; ....

Check if this is possible in your data model.

Best Regards,

Vikraant