topic Re: Expression Listbox in QlikView

Expression Listbox

felcar2013 — Mon, 04 Apr 2016 08:44:35 GMT

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

Re: Expression Listbox

Gysbert_Wassenaar — Mon, 04 Apr 2016 08:49:19 GMT

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.

Re: Expression Listbox

felcar2013 — Mon, 04 Apr 2016 13:11:27 GMT

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