Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to force when i select country = TMY , i want to activate TAX = 1.15 ?

Hi All

May i know how to automate the below ?

force.png

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Paul,

TAX_SUB is a field name. Are you want to show ListBox lable? If like this we may try in title expression ='TAX_SUB = ' & If(GetFieldSelections([Currency_P])='MY',1.15,1)

See attached file.

Regards,

Sokkorn

View solution in original post

4 Replies
Not applicable
Author

HI,

try to use a trigger On Any Selections with:

select in field:           TAX_SUB

value:                       if(only(Country)='TMY','HI=1.15', 'LO=1')

Hope this helps

Sokkorn
Master
Master

Hi Paul,

TAX_SUB is a field name. Are you want to show ListBox lable? If like this we may try in title expression ='TAX_SUB = ' & If(GetFieldSelections([Currency_P])='MY',1.15,1)

See attached file.

Regards,

Sokkorn

iktrayanov
Creator III
Creator III

I looked at your data model and your TRANSPORT table is not linked to anything. The easiest solution is to link your RATE and TRANSPORT tables.

Not applicable
Author

Hi Tray

I cannot link the table , As i also need the user have the flexibility to changes after automatic proposal.

Any way SOK have give the right solution.

Paul