Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi All

I report this Question again . as i never get any reply.

My question is when i click on Currency_P = TMY , I want it auto select TYPE_PRODUCT = TMY

I have try below step :-

Step 1 I create a var = vSelectValaueInType

Expression as below :-

=If(GetFieldSelections(Currency_P)='MY',TMY,TID)

Step 2 I go to trigger Tab , look for field  = Currency_P

I add an action :-

Feild = TYPE_PRODUCT

expresion :-

=$(vSelectValueInType)

I cannot make it work , any idea ?

Paul

6 Replies
MVP
MVP

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi Paul,

I saw this thread replied by someone. Don't know how the replies are not there. You probably had attached a sample as well which is no more here. Could you post the sample?

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi agree with tresco.

Paul your field Currency_P have some strange values.

when I try to get below expression

=getcuurrentselection(Currency_P)

or

=GetFieldSelections(Currency_P)

It not returning the same values.

Other then that the solution proposed by jagan must work.

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

may be Jagan Mohan can help you here.

Regards

ASHFAQ

MVP
MVP

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi Paul,

Did you add Select In Field Trigger for the Field?  Check this thread hope it helps you.  Can you attach some sample file

Select in Field Trigger with Single or Multiple values

=If(GetFieldSelections(Currency_P)='MY',TMY,TID)


In the above is TMY and TID are fields are values, if those are values then then try this


=If(GetFieldSelections(Currency_P)='MY','TMY','TID')

Hope this helps you.

Regards,

Jagan.

paulyeo11
Valued Contributor II

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi Tres

I accidently delete the 2 msg.

Now is working fine . After Sat post me a sample script . Now I know where I go wrong. 

Paul

Sent from Samsung Mobile

paulyeo11
Valued Contributor II

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi Ash

It work fine now. Thank a lot.

Paul

Sent from Samsung Mobile

paulyeo11
Valued Contributor II

Re: when i select Currency_P=TMY how can i make TYPE_PRODUCT=TMY activated ?

Hi sir

It work fine now.

Paul

Sent from Samsung Mobile

Community Browser