How to have selective data in a List Box

[#1]

Hi,

I am using Quickbooks advanced reporting which is powered by Qlikview, I am trying to use a listbox [Item.Full Name].

Yet we have many items that we do not want on the list box. is there a way i can select just the items i want to be shown in the listbox?

This is the expression I have entered into the List Box Field.

=If([Item.Full Name]='SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])

This returns an Error.

Thank you very much,.

[Anil_Babu_Samineni]

This?

=If(Match([Item.Full Name]), 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])

[#3]

Thank you very much

[vishsaggi · Accepted solution]

Just a small correction Anil, Close the bracket for Match after last value like

= If(Match( [Item.Full Name] , 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS' ) , [Item.Full Name] )

[Anil_Babu_Samineni]

Awesome, Please close this thread by flag correct answer

Qlik Community Tip: Marking Replies as Correct or Helpful