Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor

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

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

4 Replies
Not applicable

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

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
Honored Contributor

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

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
Contributor III

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

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

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

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

Community Browser