stacked bar chart and connect to list box

[nazaninslp]

Dears

I have stacked bar chart with below info 

dimension: date_m (drildown(group))

expression: 

Bar:

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"KIOSK"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"WAP"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"CC (CRM)"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"SP website"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"Other"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"SMS"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"WEB"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"USSD"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"IVR"}>}Total_Channels)

=Sum({<Action_Channels={"NEW_SUBSCRIBE"},Channel_Description={"MDSP CC Portal"}>}Total_Channels)

Line:   Sum({<Action_Channels={"NEW_SUBSCRIBE"}>}Total_Channels)

and I have also list box with below expression :

=if(Match(Channel_Description,'KIOSK','WAP','CC (CRM)','SP website','Other','SMS','WEB','USSD','MDSP CC Portal','IVR',''),Channel_Description)

my problem is that when I choice one of items in my list box, my stacked chart doesn't show the item value and shows all of them.

would you please help me how can I show 1 item when i press in list box.

my stacked chart without choosing items in list box:

After choosing 1 item in list box: 

[sunny_talwar · Accepted solution]

Try changing your expressions to these

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"KIOSK"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"WAP"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"CC (CRM)"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"SP website"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"Other"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"SMS"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"WEB"}>}Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"USSD"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"IVR"}>} Total_Channels)

=Sum({<Action_Channels = {"NEW_SUBSCRIBE"}, Channel_Description *= {"MDSP CC Portal"}>} Total_Channels)

[nazaninslp]

Thank you Dear, it is working fine

would you please explain that why mt expression didn't work without *=?

[sunny_talwar]

You will get you answer in the below blog

Implicit Set Operators