Alternate State in Set Analysis

[tresesco]

Hello,

I am selecting from two different states (calculated dimensions (Field1 - State1, Field2- State2)) and my Date field is in default state. I have to take the max date from that date field which. How do i tell that my my date field's state?

See, the below expressions: the one with IF works fine. I want the same with Set Analysis.

Sum({State2+State3}if(Date=vUIMaxDate,Rate))- OK

Sum({State3+State2<[Date]={'$(vUIMaxDate)'}>}Rate) - Wrong (probably because i have to specify somehow that Date is in default state).

Thanks.

[kumarnatarajan]

Hi,

Refer below mentioned URL:

http://community.qlik.com/message/209604#209604

[tresesco]

Thanks Kumar. I am still not clear(though not yet took a deep look) how to implement my scenario  as it contains a variable in the default state. i will still take a close look at the discussion you referred.

[AbhijitBansode]

Refer below URL:

http://qlikboard.com/2012/12/04/set-analysis-alternate-states-quick-tip/

Regards,

Abhijit