topic Re: Is possible to use alternate States with set analysis in QlikView

Is possible to use alternate States with set analysis

bruno_m_santos — Wed, 11 Apr 2012 16:21:16 GMT

Hello,

I'm new with alternate states.

It's possible to use alternate states (ie use Group1) with a set analysis syntax as below? Can you give a sample please?

=Count({$<MonthID = {"<=$(=Max(MonthID))"},
Date = {"<=$(=Max(Date))"},
Year = {$(=Max(Year))},
Quarter = ,
Period = ,
[Period (#)] = ,
Month = >}Operacoes_DetalheKey)

Many Thanks

Bruno

Is possible to use alternate States with set analysis

CELAMBARASAN — Wed, 11 Apr 2012 16:37:21 GMT

Hi,

Try with this

=Count({Group1<MonthID = {"<=$(=Max(MonthID))"},

Date = {"<=$(=Max(Date))"},

Year = {$(=Max(Year))},

Quarter = ,

Period = ,

[Period (#)] = ,

Month = >}Operacoes_DetalheKey)

Celambarasan

Re: Is possible to use alternate States with set analysis

agilos_mla — Wed, 11 Apr 2012 19:13:51 GMT

Hi, Here is a sample of set analysis syntax with alternate states. Use [State Identifier] and ::

Function({[state_identifier1] <field_name2= [state_identifier2]::field_name3>}field_name)

Set values for field_name2 within [state_identifier1] basedon values of field_name3 in [state_identifier2]

e.g. sum({Group1} <Year=$::Year> Sales)

e.g. avg({MarketDev} <Year={BaseLine}::Year,Category={Global}::ProductCategory>SalesLeadTime

Achieving the same thing with 2 differentsyntax:

Option 1 - sum({[Group 1]<Region =$::Region, [Sales Rep] = $::[Sales Rep], Path = $::Path, Year= $::Year, Quarter = $::Quarter, Month = $::Month>} Sales)

Option 2 - sum({$<[Product Sub Group]= [Group 1]::[Product Sub Group] >} Sales)

Hope that helps,

Michael

Re: Is possible to use alternate States with set analysis

bruno_m_santos — Thu, 12 Apr 2012 09:36:25 GMT

Thanks Michael,
Your tip was very helpful.
Can you just clarify for me what would I use the syntax described in option 1.
Bruno

Is possible to use alternate States with set analysis

CELAMBARASAN — Thu, 12 Apr 2012 09:49:42 GMT

Hi,

$:: is to use the selection in the default state filters.instead of $ you can specify the group name to synchronize with it

Can you tell me what your trying to achieve?

Celambarasan

Re: Is possible to use alternate States with set analysis

bruno_m_santos — Thu, 12 Apr 2012 11:23:48 GMT

Hi Michael,

I'm just trying to understand the logic, because i'm debugging the reason why I have different results for the alternate state (Group1) of what I have without using the "alternate state" but simulating the same conditions.

I'll update this forum.

Thanks

Bruno

Re: Is possible to use alternate States with set analysis

Thu, 26 Apr 2012 21:28:59 GMT

I'm trying to follow some of Michael's examples, but I'm getting errors in the "::" and "$::" syntax. I've tried playing around with all the examples above but am still not successful.

I have a measure (Sales), and I've created two Groups (Group1 and Group2), both are there to select/compare date ranges). I want to be able to select other filters/list boxes and also have them apply to the Bar chart...I've made those other list boxes alternate states, too (for example: variable Partner I called Partner1...variable Channel I've named Channel1, etc.). I'm trying to figure out how to get those alternate states into the Sales expression.

Any more samples or logic/concepts that can help me? Thanks!

Re: Is possible to use alternate States with set analysis

lorenwood — Tue, 14 Aug 2012 21:57:29 GMT

Thanks this really helped, Loren

Re: Is possible to use alternate States with set analysis

Wed, 21 Nov 2012 09:44:08 GMT

Use the syntax with the [ ] brackets

=(SUM( { State1Name < [Field1]=[State2Name]::Field1>} Sales )

Ran into the same problem with the curly braces { }

Rgds

Re: Re: Is possible to use alternate States with set analysis

Tue, 26 Nov 2013 11:08:24 GMT

Hi Michael,

I have tried this but in my sample application, I am not getting how is my thired expression's output is coming (need some explanation on it).

PFA for my sample App. And it will be great if you explain your other options too.

Thanks in Advance!!!

-Yojas

Re: Is possible to use alternate States with set analysis

Mon, 13 Oct 2014 14:21:43 GMT

Your first two 'e.g's in blue seem to have the closing curly bracket in the wrong place?

Shouldn't it be:

e.g. sum({Group1 <Year=$::Year> } Sales)

e.g. avg({MarketDev <Year={BaseLine}::Year,Category={Global}::ProductCategory> } SalesLeadTime

With closing curly bracket just before the final field_name that you wish to aggregate, such as Sales or SalesLeadTime.

Re: Is possible to use alternate States with set analysis

Thu, 27 Nov 2014 07:13:27 GMT

Can we have conditional?

Means

ex.

I have global filter Brand,Country, Yardstick.

and One alternate state.

I want to change data in alternate state by using Yardstick where yardtick is radio button b/w R3M, YTD, Month.

Can we have this type of set analysis in if condition?

Re: Is possible to use alternate States with set analysis

saveriospa — Fri, 26 Jun 2015 16:12:22 GMT

Hi Michael.

Your tip was very helpful to solve my problem too !!

I've another question .... starting from this expression (i've defined an alternate state "StateB"):

sum({<KPI={'Production'},Period=StateB::Period, Quarter=StateB::Quarter, Month=StateB::Month>} Actual)

If i need to filter Month for the maximum Month selected, how can i do?

Many Thanks!!

Saverio

Re: Is possible to use alternate States with set analysis

Anonymous — Wed, 13 Apr 2016 09:43:02 GMT

Hi,

i have similar problem:

=Sum({$<MO_ID={21}, Rok = {$(=only('20'&(Left([Rok-Miesiąc],2)-2)))}, Miesiąc={"<=$(=Max(Right([Rok-Miesiąc],2)))"}, [Rok-Miesiąc]=>}KwotaW

I tried to do this like that:

=Sum({$[stan1]<MO_ID={21}, Rok = {$(=only('20'&(Left([Rok-Miesiąc],2)-2)))}, Miesiąc={"<=$(=Max(Right([Rok-Miesiąc],2)))"}, [Rok-Miesiąc]=>}KwotaW

but it doesnt work.

Maybe i should set stan1 for all fields, so for Rok, Miesiąc, Rok-Miesiąc?

stan1 is connected with field Rok-Miesiąc.

Please help me,

Best Regards,

Jacek Antek