Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Expression Listbox

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

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Highlighted
Partner
Partner

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