set expression didn't work

Tue, 18 Jun 2013 08:46:49 GMT

Hi,

below expression works fine.

=FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<TRX_DATE ={'<=$(vSelectedDate)'}>}MAX_TRX), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE))))

but when I used it in blow way then it doesn't work -

=$(=FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<TRX_DATE ={'<=$(vSelectedDate)'}>}MAX_TRX), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE)))))

it returns fixed highest value in all row like 20130531.

i want to use number 2 option in set analysis below way and its first greater portion doesn't work -

=sum({<SR_SALES_TRX_FRMT_DAY={">$(=FirstSortedValue($(v_INV_TRX_DATE), -(aggr(max({<$(v_TRX_DATE)={'<=$(vSelectedDate)'}>}$(v_MAX_TRX)), $(vWarehouse),$(v_PRODUCT_CODE), $(vItem),$(v_TRX_DATE)))))<=$(vSelectedDateNew)"}>}SALES_ORD_INV_QTY)

Could please help me regarding this.

thanks in advance

topic set expression didn't work in QlikView

set expression didn't work