topic Re: alphanumeric values in listbox in QlikView

alphanumeric values in listbox

sibideepak — Thu, 18 Sep 2014 12:07:36 GMT

Hi ,

I have Number field which contains mixed values like 001,AB1,005,etc...

I want to filter the values other than numbers in one field ...

I used the following expression which work as my desire but it shows only value select other are

hidden because of only function, i want the listbox which always shows the alphanumeric value.

=aggr(only({<Number-={"=if(isnum(Number),Number)"}>}Number),Number)

MK_QSL — Thu, 18 Sep 2014 12:09:17 GMT

Can you please let us know what is the meaning of

I want to filter the values other than numbers in one field ...

Thu, 18 Sep 2014 12:14:19 GMT

try like this

purgechar ( 'a1b2c3','123' ) returns 'abc'

ecolomer — Thu, 18 Sep 2014 12:15:31 GMT

You can use:

purgechar (yourfield, '01234567890')

Thu, 18 Sep 2014 12:17:34 GMT

try this demo

LOAD PurgeChar(field,'0123456789') as newfield;

load * Inline [

field

ab1

012df

gh5j

]

ashfaq_haseeb — Thu, 18 Sep 2014 12:18:53 GMT

Try this

purgechar (yourfield, '01234567890') --> To get Text Values

keepchar (yourfield, '01234567890') --> To get numerical Values

Regards

ASHFAQ

Anonymous — Thu, 18 Sep 2014 12:20:34 GMT

if you use purgechar(Numberfield,'0123456789') you only get the part without numbers

you say you want a listbox containing all non numeric fields

can you use an Expression in the listbox with the purgechar function?

in the listbox you will always see all values (some green, some white, some gray)
as Long as you didnot select "exclude"

sibideepak — Thu, 18 Sep 2014 12:26:37 GMT

If you understand the expression i used for that listbox ..you will know what i want..