Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Set Analysis and Alternate State

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!

1 Solution

Accepted Solutions
Not applicable

Re: Set Analysis and Alternate State

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

12 Replies

Re: Set Analysis and Alternate State

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 ?

Not applicable

Re: Set Analysis and Alternate State

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).

Capturar.JPG

Not applicable

Re: Set Analysis and Alternate State

Try,

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

Thanks,

Vinod Kumar V

Not applicable

Re: Set Analysis and Alternate State

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

Not applicable

Re: Set Analysis and Alternate State

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

Not applicable

Re: Set Analysis and Alternate State

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

I reckon it should work as per your needs.

Do you have reason to believe it does not ?

Not applicable

Re: Set Analysis and Alternate State

I solved the problem.

Thank you for youur attention, Bill.

Not applicable

Re: Set Analysis and Alternate State

Fernando,

Can you post the solution?

Thanks,

Pedro Netto

Community Browser