Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Need check of expression

Hi Community,

I got the following Code:

=SUM({<Companyname = , TransactionDate = {">=(=MIN(TransactionDate)$<"} OpeningBalanceAmount)

Should display the openingsamount of the first TransactionDate

=SUM({<Companyname = , TransactionDate = {">=(=MAX(TransactionDate)$<"} ClosingBalanceAmount)

Should display the closingamount of the lastTransactionDate

What is wrong with the code? It keeps returing empty.

1 Solution

Accepted Solutions

Re: Need check of expression

Try these:

SUM({<Companyname= ,TransactionDate={'$(=MIN(TransactionDate))'}>} OpeningBalanceAmount)

SUM({<Companyname= ,TransactionDate={'$(=MAX(TransactionDate))'}>} OpeningBalanceAmount)

And make sure your TransactionDate field contains real dates (i.e. numbers, optionally formatted as dates) and not strings.


talk is cheap, supply exceeds demand
2 Replies

Re: Need check of expression

Try these:

SUM({<Companyname= ,TransactionDate={'$(=MIN(TransactionDate))'}>} OpeningBalanceAmount)

SUM({<Companyname= ,TransactionDate={'$(=MAX(TransactionDate))'}>} OpeningBalanceAmount)

And make sure your TransactionDate field contains real dates (i.e. numbers, optionally formatted as dates) and not strings.


talk is cheap, supply exceeds demand
Not applicable

Re: Need check of expression

Thanks, the code below did it for me. for the extra information!

=SUM({<Rekeningnummer=, Bedrijfsnaam=, CalendarDate= '$(=Minstring(CalendarDate))'}>}OpeningBalanceAmount*DebitCreditFactor)

Community Browser