Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have a Listbox "Memberchannel" which contains this Expression:
=if(GetFieldSelections(Name1) ='indicator1',reportchannel,if(match(reportchannel,'Ecom','Retail'),reportchannel))
from the Expression:
- Name1 is another listbox with two values: indicator1 and indicator2
- reportchannel field contains : Ecom, Retail, Franchising
when i select Indicator1, i should get all three field values from Report channel, otherwise only Ecom and Retail. I get this correct, but then when i select any value in the listbox "Memberchannel" (out of the Expression), the selection does not work.
thanks for any help
felipe
The text string 'indicator1' is not related to your data model. Clicking on it won't do anything. You can try creating a new field in the script:
NewTable:
LOAD * INLINE [
ListBoxField, reportchannel
indicator1, Ecom
indicator1, Retail
indicator1, Franchising
Ecom, Ecom
Retail, Retail
Franchising, Franchising
];
Then you the new ListBoxField as field for your listbox.
thanks for the proposal
i created a new field in the script and duplicated the listbox for both fields. Then I applied the condition to the layout (1 or 0) in the listbox and i got what i wanted,
thanks
felipe