Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,.
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] )
This?
=If(Match([Item.Full Name]), 'SH318CKASS','SH318FASS','SH318RVASS','SH318SKASS',[Item.Full Name])
Thank you very much
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] )
Awesome, Please close this thread by flag correct answer
Qlik Community Tip: Marking Replies as Correct or Helpful