topic Re: Hide Certain Selections from List Box in QlikView

Hide Certain Selections from List Box

Mon, 01 Jul 2013 09:12:00 GMT

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.

Re: Hide Certain Selections from List Box

narender123 — Mon, 01 Jul 2013 09:18:42 GMT

Hi.

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

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

Thanks.

Narender

Re: Hide Certain Selections from List Box

Mon, 01 Jul 2013 09:20:28 GMT

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

Re: Hide Certain Selections from List Box

Mon, 01 Jul 2013 09:21:22 GMT

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

Re: Hide Certain Selections from List Box

narender123 — Mon, 01 Jul 2013 09:23:53 GMT

Hey.

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

Narender

Re: Hide Certain Selections from List Box

Mon, 01 Jul 2013 09:46:25 GMT

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

Many Thanks, Adam.

Re: Hide Certain Selections from List Box

Mon, 01 Jul 2013 09:46:40 GMT

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

Many Thanks, Adam.

Re: Hide Certain Selections from List Box

er_mohit — Mon, 01 Jul 2013 09:51:24 GMT

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

Re: Hide Certain Selections from List Box

Tue, 02 Jul 2013 13:57:13 GMT

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