Expressions

Thu, 21 Jan 2016 19:47:47 GMT

Hello,

I am using this expression with a Text Object.

= num (sum({<[Open Collections Loss Type]={'Chargeback'},[Open Collections Date]={'1/19/2016'}>} [Open Collections Amount]), '$##,###.##')

This has worked fine. My issue though, I would like to use other items such as 'Deposit' too add along with chargeback.

Also, with my date I would like to use a range i.e. 1/1/2016- 1/19/2016.

Thank you,

Manny

Re: Expressions

sunny_talwar — Thu, 21 Jan 2016 19:54:35 GMT

Try this:

=Num(Sum({<[Open Collections Loss Type]={'Chargeback', 'Deposit'},[Open Collections Date]={'>=1/1/2016<=1/19/2016'}>} [Open Collections Amount]), '$##,###.##')

topic Re: Expressions in QlikView

Expressions

Re: Expressions