topic Set Analysis and Alternate State in QlikView

Set Analysis and Alternate State

Wed, 24 Jun 2015 13:21:36 GMT

Hi,

I created an text object in a alternate state (S2) with the follow expressions:

=Sum({<
ID_REF_ATEND = {6}
,CD_SETOR_REF_ATEND = p([S1]::CD_SETOR_REF_ATEND)
,DT_REF_ATEND = {$(=Num(MonthStart(min([Período Adm/Alta Setor]))))}
>}CONT_REF_ATEND)

My problem is here: DT_REF_ATEND = {$(=Num(MonthStart(min([Período Adm/Alta Setor]))))}

The field [Período Adm/Alta Setor] is in default state. Does anyone knows how get the selection of this field?

thanks!

Re: Set Analysis and Alternate State

Anonymous — Wed, 24 Jun 2015 13:26:07 GMT

Is it that you want the field [Período Adm/Alta Setor] to be in the Default State or that you want it in another state ?

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 13:37:20 GMT

I want to make a selection in the field [Período Adm/Alta Setor] (this field is in default state) and get a result in a object that is in a diferent state (S2).

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 13:45:54 GMT

Try,

min({S1} [Período Adm/Alta Setor])

Thanks,

Vinod Kumar V

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 13:48:30 GMT

[Período Adm/Alta Setor] IS IN DEFAULT STATE.

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 13:52:17 GMT

You want it to be default state or change it to S2?

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 14:01:32 GMT

I don't want to change the states of objects.

The field [Período Adm/Alta Setor] (list object) is in default state. I'll use this field do make selectios, filters.

In other object (text object in Alternate State S2), with the expression bellow, I want the result.

=Sum({<

ID_REF_ATEND = {6}

,CD_SETOR_REF_ATEND = p([S1]::CD_SETOR_REF_ATEND)

,DT_REF_ATEND = {$(=Num(MonthStart(min([Período Adm/Alta Setor]))))}

>}CONT_REF_ATEND)

Re: Set Analysis and Alternate State

Anonymous — Wed, 24 Jun 2015 14:03:00 GMT

I reckon it should work as per your needs.

Do you have reason to believe it does not ?

Re: Set Analysis and Alternate State

Wed, 24 Jun 2015 17:47:05 GMT

I solved the problem.

Thank you for youur attention, Bill.

Re: Set Analysis and Alternate State

Fri, 04 Sep 2015 17:18:59 GMT

Fernando,

Can you post the solution?

Thanks,

Pedro Netto

Re: Set Analysis and Alternate State

Tue, 05 Jan 2016 10:58:16 GMT

And the solution is?

Re: Set Analysis and Alternate State

Tue, 05 Jan 2016 12:34:30 GMT

$::[Período Adm/Alta Setor]

Re: Set Analysis and Alternate State

Tue, 05 Jan 2016 12:34:39 GMT

$::[Período Adm/Alta Setor]