Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi.
try this under general>field>select expression ,of list box
if(Document Type={'Sales Order','Sales Return'},Document Type)
Thanks.
Narender
Hi.
try this under general>field>select expression ,of list box
if(Document Type={'Sales Order','Sales Return'},Document Type)
Thanks.
Narender
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
Rather do what Narender suggested, a better way of writing the above
Hey.
I am saying the same thing.Check my reply first .You are also saying the same as i said.
Narender
Hello. Thank you so much for your help Narender. I am very grateful!
Many Thanks, Adam.
Hello. Thank you so much for your help Byron. I am very grateful!
Many Thanks, Adam.
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
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