Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

list box only with several data

Hi,

I have a list box that contains the status for every invoice I have:

invoice         status            €


PV001          01               10

PV002          01               10

PV003          01               05

PV004          99               05

PV005          99               06

PV006          02               08

I want a list box only with codes 10 and 05 the rest I don't want to be in the list code!

Thank's

Eduard

1 Solution

Accepted Solutions
Not applicable

Hi,

He wants the field '€' and not the 'status'.

😃

By Rebeca

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use an expression for your listbox: =if(status='10' or status='05',status)


talk is cheap, supply exceeds demand
Not applicable

Hi!

You can create an expression from the list, as below:

=if( = 10 or = 5,)

By Rebeca

Not applicable

Hi,

He wants the field '€' and not the 'status'.

😃

By Rebeca

ecabanas
Creator II
Creator II
Author

thank's Gysbert!!!