How to write set analysis ?

[suvechha_b]

Hi all,

How to write set analysis ?

My expression :

sum({$<TranType = {$(vAmountType)}>} Amount)

I need the sales should be calculated on current_date but the results is only displaying for trans Date 20140206 .

Thanks,

[suvechha_b]

Please find the sample attached.

[sunny_talwar]

It seems that your data model is what might be causing the issue. Look at this table box

It seems that Amount values repeat for each of the current_date. Now how would you decide which Amount value should show up for which current_date? Attaching the qvw back with the table box for you to see.