Hide Certain Selections from List Box

[#1]

Hi All,

Struggling a little on this one... I have a list box which outlines "Document Type" e.g.

Pro Forma Invoice

Quotation

Repeat Template

Sales Order

Sales Return

T e-Mail Order

T e-Mail Return

Tax Only Credit Note

Tax Only Invoice

I only want to allow my users to click "Sales Order" or "Sales Return".

Can anybody offer any advice on an expression to allow me to do this? (if it's even possible!)

Many Thanks!

Adam.

[narender123 · Accepted solution]

Hi.

try this  under general>field>select expression ,of list box

if(Document Type={'Sales Order','Sales Return'},Document Type)

Thanks.

Narender

[#3]

Hi Mate,

In the list box general options where you click the drop down to select a field to represent > scroll down to the bottom and click expression

in there write this

If(FieldName = 'Sales Order' or FieldName = 'Sales Return',FieldName)

This will then only produce a list box with those 2 options

Let me know if you come right man

Cheers,

Byron

[#4]

Rather do what Narender suggested, a better way of writing the above

[narender123]

Hey.

I am saying the same thing.Check my reply first .You are also saying the same as i said.

Narender

[#6]

Hello. Thank you so much for your help Narender. I am very grateful!

Many Thanks, Adam.

[#7]

Hello. Thank you so much for your help Byron. I am very grateful!

Many Thanks, Adam.

[er_mohit]

try this in list box go to properties-->General--> in field drop down it go to atlast you ll see expression there click on it then add this expression and on title write field name Document Type

=if(WildMatch([Document Type],'Sales Order','Sales Return'),[Document Type])

hope it helps

[#9]

BTW, I didn't realise at the time that curly brackets would fail on this expression i.e...Year={'example1','example2'}.

Does anyone know if this worked on previous versions. I am on 11.20 atm.

@er.mohit, I will use this method going forward

@adampj87. Anytime mate! Hope you enjoy using qlikview and don't be shy to ask. This community really supports each other