topic Re: Alternate state in set analysis in QlikView

Alternate state in set analysis

senarath — Thu, 22 Jan 2015 16:20:12 GMT

Hi,

I want to create a comparison between two states (StateA and StateB) for below expression.

Appreciate if anybody could help me out to complete the formula using states

Let's assume Dim is Company.

Sum({$<[Business Date]={'>=$(=Date(vStartDate)) <=$(=Date(vEndDate))'},[Boat Name]=,Type={Actual},Year=,Quarter=,Month=,Week=,Day=>} [Cruise Nights])

Thanks

Senarath

Re: Alternate state in set analysis

Anonymous — Thu, 22 Jan 2015 19:53:50 GMT

Hi, which fields of yours are in alternate states?

If all of them, you can try

Sum({[StateA]}<[Business Date]={'>=$(=Date(vStartDate)) <=$(=Date(vEndDate))'},[Boat Name]=,Type={Actual},Year=,Quarter=,Month=,Week=,Day=>} [Cruise Nights])

versus

Sum({[StateB] }<[Business Date]={'>=$(=Date(vStartDate)) <=$(=Date(vEndDate))'},[Boat Name]=,Type={Actual},Year=,Quarter=,Month=,Week=,Day=>} [Cruise Nights])

If some of fields are in ordinary state you can use in set analysis a syntax like Year=$::Year

This one for your reference:

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

Elena

Re: Alternate state in set analysis

senarath — Fri, 23 Jan 2015 03:37:00 GMT

Hi Elena,

I tried what you have mentioned. But what I do not understand is how to apply $:: to other expanded areas.

I had read your link as well and still I do not clear as to how to apply $::.

Thanx

Re: Alternate state in set analysis

Fri, 23 Jan 2015 09:25:10 GMT

The :: denotes a linkage between the fields, so it works in a similar way as to using P(). As an example, if you have a company field that you wish to apply the alternate state to, it would be

Company = State1::Company.

The dollar sign in this instance simply ties back to the base state selections.

Re: Alternate state in set analysis

Fri, 23 Jan 2015 10:00:20 GMT

Hi Senarath,

have a look at

http://community.qlik.com/docs/DOC-4951

provides good info on set analysis and has a section on using alternate states, which should prove useful to you

hope that helps

Joe

Re: Alternate state in set analysis

senarath — Fri, 23 Jan 2015 11:32:38 GMT

Thanks a lot all...really helpful notes....!!!!