Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
Suppose I load following table
Country | Population |
India | 20 |
China | 30 |
UK | 40 |
US | 50 |
India | 60 |
Now I have two list boxes 'Country' and 'Population'.
Requirement:
If I select Country 'India' then two associated values in Population should be green by default.
This should happen to all the values in Country.
How to do this?
Note: I am working on Personal edition so QVWs won't work for me.
Thanks in advance.
Try this also..
Document Properties -> Field Event Trigger -> Add Actions ->
1. Clear Field - > Population
2. Select Possible -> Population
Load * Inline [
Country, Population
India, 20
China, 30
UK, 40
US, 50
India, 60
];
Create two list boxes then Select India from Country and see how associative will happen
You can use triggers to get this done
Select in field Trigger for Population field with the following search string
'(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'
Hi Sunny,
I have created the trigger but result is not as expected.
My output should look like
1) I don't see the field name you are triggering to -> Population here.
2) I think you are missing an equal sign before the expression I gave you
='(' & Concat(DISTINCT Chr(34) & Population & Chr(34), '|') & ')'
Try this also..
Document Properties -> Field Event Trigger -> Add Actions ->
1. Clear Field - > Population
2. Select Possible -> Population
Its not working
Hi Settu,
Its not working.
Is is possible to share the qvw you are working with?
Hi Sunny,
Please find file attached.