Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Question

I have a data set that has Pledged budget and Paid budget , so i want to get the difference between the two as available balance.

what function do i use for the subtraction fields.

Thanks.

Tags (1)
1 Solution

Accepted Solutions
RonaldDoes
Contributor III

Re: Question

Is there any reason you could not use an expression like:

=Sum([Pledged amount]) - Sum([Paid amount])

9 Replies
mwoolf
Honored Contributor II

Re: Question

If Pledged budget and Paid budget are tin the same table:

rangesum(Pledged,-Paid) as Balance,

Not applicable

Re: Question

Hi M W

They both are on different tables

ahaahaaha
Honored Contributor

Re: Question

Hi Saran,

Can there be a fragment of the original data in order not to guess?

Regards,

Andrey

Not applicable

Re: Question

the data is on 2 excel sheets one .in an excel shit we have a column containing payment in usd, on the other excel shit we have pledges in usd. now i need to subtract amount pledged from amount paid so that i can know the amount the donor has not paid that's the balance @Andrey Khoronenko .

Re: Question

When you say shit do you mean sheet - or do you mean excel is rubbish ?

Not applicable

Re: Question

Thats a typo its sheet.

RonaldDoes
Contributor III

Re: Question

Is there any reason you could not use an expression like:

=Sum([Pledged amount]) - Sum([Paid amount])

stantrolav
Contributor II

Re: Question

Use

RangeSum(

     Sum([Pledged budget]), -Sum([Paid budget])

                  )

RangeSum function is used for calculations with NULL values.

Not applicable

Re: Question

thanks it worked

Community Browser