topic Re: Select in Field in QlikView

Select in Field

MK_QSL — Sun, 05 Jan 2014 12:49:26 GMT

I have employee code either starting with Alphabet or Number.... it is mixed of both....

What should I write in Text Box - Action - Select in Field - Search String to get all employee code starting with Alphabets only...

i.e. starting with any Alphabet from A to Z...

Re: Select in Field

Sun, 05 Jan 2014 13:37:14 GMT

Hi Manish,

Try this (if your values don't contain spaces, then omit the replace function, put your fieldname only):

='(' & Concat({1} distinct if(IsText(Left(FieldName,1)), Replace(FieldName, ' ', '*')), '|') & ')'

Hope this helps.

Re: Select in Field

simondachstr — Sun, 05 Jan 2014 14:18:22 GMT

Another idea would be to include another column in your loading script, stating that any employee starting with a letter , should get a 1, employees starting with a number should get a 0.

e.g. if(isText(Left(FieldName,1)),1,0) as EmployeeLetterStart

In Action you will then use Trigger, Select Possible, Only({<EmployeeLetterStart={'1'}>} FieldName)

Using this will be much much more faster in the front end.

Re: Select in Field

MK_QSL — Sun, 05 Jan 2014 14:18:51 GMT

Hi Jean,

This working fine but definitely there should be some easy way....!!

Re: Select in Field

maxgro — Sun, 05 Jan 2014 14:30:24 GMT

not very nice but it works

='("a*"|"b*"|"c*")'

Regards

Re: Select in Field

rbecher — Sun, 05 Jan 2014 20:36:54 GMT

Hi Manish,

try something like this:

='=ord(left(Field,1))>64'

- Ralf

Re: Select in Field

brijesh1991 — Mon, 06 Jan 2014 04:52:43 GMT

Write this expression in a list box edit expression

if(isText(Mid(FieldName,1,1)),EmployeeCode)

And then right click over listbox and select all.

Re: Re: Select in Field

rbecher — Mon, 06 Jan 2014 06:38:21 GMT

Even this works:

='=ord(Field)>64'

..most simple.