Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Hide Certain Selections from List Box

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.

Tags (3)
1 Solution

Accepted Solutions
narender123
Valued Contributor

Re: Hide Certain Selections from List Box

Hi.

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

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

Thanks.

Narender

8 Replies
narender123
Valued Contributor

Re: Hide Certain Selections from List Box

Hi.

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

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

Thanks.

Narender

Not applicable

Re: Hide Certain Selections from List Box

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

Not applicable

Re: Hide Certain Selections from List Box

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

narender123
Valued Contributor

Re: Hide Certain Selections from List Box

Hey.

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

Narender

Not applicable

Re: Hide Certain Selections from List Box

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

Many Thanks, Adam.

Not applicable

Re: Hide Certain Selections from List Box

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

Many Thanks, Adam.

er_mohit
Honored Contributor II

Re: Hide Certain Selections from List Box

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

Not applicable

Re: Hide Certain Selections from List Box

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

Community Browser