topic Re: what is wrong with this expression in QlikView

what is wrong with this expression

Wed, 28 May 2014 22:22:38 GMT

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

Re: what is wrong with this expression

SergeyMak — Thu, 29 May 2014 01:26:08 GMT

Hi,

try post a sample app.

Re: what is wrong with this expression

jagan — Thu, 29 May 2014 02:12:00 GMT

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.