Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mjmilian
New Contributor III

List Box

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?

Tags (2)
11 Replies
Partner
Partner

Re: List Box

Hi Matt,

try this:

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

mjmilian
New Contributor III

Re: List Box

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

mjmilian
New Contributor III

Re: List Box

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


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

Partner
Partner

Re: List Box

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.

mjmilian
New Contributor III

Re: List Box

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.

Highlighted
Partner
Partner

Re: List Box

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

mjmilian
New Contributor III

Re: List Box

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

MVP & Luminary
MVP & Luminary

Re: List Box

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
Contributor III

Re: List Box

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) ​