topic Re: Alternate State in Set Analysis in QlikView

Alternate State in Set Analysis

tresB — Tue, 18 Jun 2013 11:00:24 GMT

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.

Re: Alternate State in Set Analysis

kumarnatarajan — Tue, 18 Jun 2013 11:12:24 GMT

Hi,

Refer below mentioned URL:

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

Re: Alternate State in Set Analysis

tresB — Tue, 18 Jun 2013 11:33:43 GMT

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.

Re: Alternate State in Set Analysis

AbhijitBansode — Tue, 18 Jun 2013 11:55:09 GMT

Refer below URL:

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

Regards,

Abhijit