Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is wrong with this expression

hi,

I got one expression

FirstSortedValue({1<Transactions.TxnDate={If (MonthName(Min({1<Transactions.TxnType={'Invoice'}>}Transactions.TxnDate)) = MonthName(Max(Transactions.TxnDate)), Transactions.TxnDate)}>}Customer.CustomerListID,Transactions.TxnDate)

It is showing error at red colored comma (,) after MonthName(Max(Transactions.TxnDate)) on the second line ...

Regards,

Saurabh

2 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

Hi,

try post a sample app.

Regards,
Sergey
jagan
Luminary Alumni
Luminary Alumni

Hi Ramya,

Try to post some sample and explain what is your expected output.

Try this expression

FirstSortedValue({1<Transactions.TxnDate={'$(=If (MonthName(Min({1<Transactions.TxnType={'Invoice'}>}Transactions.TxnDate)) = MonthName(Max(Transactions.TxnDate)),Transactions.TxnDate))'}>}Customer.CustomerListID,Transactions.TxnDate)

Regards,

Jagan.