topic Re: Expression List Box in QlikView

Expression List Box

Tue, 22 Apr 2014 10:21:04 GMT

Hi All

I have a list box which has thousands invoice numbers. The invoice numbers either start with "ICT" or "INV".

I want to create a list box where there are only 2 options and below is my formula , however it does not work

=if([Document No] like 'ICT', 'Trade Counter' , 'Head Office') .

Please can you help and where i am going wrong in the formula?

kind regards

Nayan

MK_QSL — Tue, 22 Apr 2014 10:22:53 GMT

=IF(WildMatch([Document No],'ICT*'),'Trade Counter' , 'Head Office')

Tue, 22 Apr 2014 10:25:15 GMT

Thank you Manish. It worked. Much appreciated.

kind regards

Nayan

anbu1984 — Tue, 22 Apr 2014 10:36:33 GMT

=if([Document No] like 'ICT*', 'Trade Counter' , 'Head Office')

=if(Left([Document No],3) = 'ICT', 'Trade Counter' , 'Head Office')

MK_QSL — Tue, 22 Apr 2014 10:55:14 GMT

easiest way is to create a flag in script just below [Document No] as below...

=IF(WildMatch([Document No],'ICT*'),'Trade Counter' , 'Head Office') as Flag

Now use Flag as List Box