topic Re: Creating a "Total" box based on amount fields in QlikView

Creating a "Total" box based on amount fields

Wed, 25 Nov 2020 16:16:04 GMT

I am new to Qlik so this may be simple...

I am looking to create a statistics box at the top that will show the total sum of a certain field given a condition. For example, I want to create a box that just has "Total Assets: $650.00", and another one that would say "Total Liabilities: $50.00". Hopefully this is a simple solution!

Account Type	Account Number	Amount
Asset	1100	$100.00
Asset	1200	$350.00
Liability	2200	$50.00
Equity	3410	$105.00
Asset	1300	$200.00

Re: Creating a "Total" box based on amount fields

el_aprendiz111 — Thu, 30 Mar 2017 22:07:02 GMT

Hi,

texbox1

=sum({<[Account Tpe={'Assent'}>}Ammount)

textbox2

=sum({<[Account Tpe={'Liability'}>}Ammount)

Re: Creating a "Total" box based on amount fields

el_aprendiz111 — Thu, 30 Mar 2017 22:07:36 GMT

Hi,

texbox1

=sum({<[Account Tpe]={'Assent'}>}Ammount)

textbox2

=sum({<[Account Tpe]={'Liability'}>}Ammount)

Re: Creating a "Total" box based on amount fields

devarasu07 — Thu, 30 Mar 2017 23:56:50 GMT

Hi,

Try like below,

Text Box object: 1

='Total Liabilities: '& num(sum({<[Account Type]={'Liability'}>}Amount),'$#,##0.00')

Text Box object: 2

='Total Assets: '& num(sum({<[Account Type]={'Asset'}>}Amount),'$#,##0.00')

Thanks,

Deva