Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Highlighted

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
Highlighted

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