List Box

[MIKIEMILLER]

I have these field names:

Unit

Total

Cash

Credit

Tip

Date

Year

Card Type

I want to have a list box that contains only these fields: Total, Cash, Credit, and Tip.

What is the easiest way about doing this?

[PabloTrevisan]

Hi Matt,

try this:

If(Match(FIELD,'Total','Cash','Credit','Tip'),FIELD)

[MIKIEMILLER]

Thanks Pablo, I have seen this before and couldnt figure out how/where this works?  does this go in the load editor?

[MIKIEMILLER]

Also I cannot figure out what FIELD is because Qlik is saying it doesnt recognize it.

If(Match(FIELD,'Total','Cash','Credit','Tip'),FIELD)

[PabloTrevisan]

Could you send me your .qvf ?

Look that 'FIELD' is your field that contains Unit,Total,Cash,Credit,Tip,Date,Year,Card,Type

does this go in the load editor?

No, in the listbox.

[MIKIEMILLER]

Sorry Pablo, I dont have access to the .qvf. 

I think I bit off more than I can chew on this. 

1) Unit, Total, Cash, Credit, Tip, Date, Year, Card, and Card Type are all names of individual fields. 

ie.

Unit     Total     Cash     Credit     Tip        Date     Year     Card Type

1          $200     $0          $175     $25     1/1/18     2018         MC            

2) I have looked into making a listbox, and dont understand how they are made.  I saw where someone said a listbox is the same thing as a Filter Pane, but when I put that formula in there it doesnt understand what FIELD is.

[PabloTrevisan]

Okay, now I understand what you want.

Maybe that's it, please confirm me

Do you know how to open a .qvf?

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Apps/open-app-dt.htm

[MIKIEMILLER]

I need admin password to copy the file into where I need to save it. Sorry.

[rwunderlich]

Unit     Total     Cash     Credit     Tip        Date     Year     Card Type

1          $200     $0          $175     $25     1/1/18     2018         MC           

Is that a representation of what your input data looks like?

-Rob

[manoj217]

You mentioned those are field names. please conform those are field names or field values.

if they are field names use set hideprefix='-'

else

If(Match(FIELD,'Total','Cash','Credit','Tip'),FIELD) ​