topic Expression in listbox in QlikView

Expression in listbox

christophebrault — Wed, 16 Nov 2011 13:14:50 GMT

Hi,

In my app, i have a hierarchy with different level. On a sheet, i want a listbox to show only a part of a field.

For example, in the field i have : A B C D E F G H, in my list box i juste want C D E F.

Is it possible ?

Thanks

swuehl — Wed, 16 Nov 2011 13:39:43 GMT

I think you could use something like:

=right('A B C D E F G H',len('A B C D E F G H')-index('A B C D E F G H',' ',2))

to remove the first two elements from your fields (elements separated by delimiter ' '), or in general

=right(YOURFIELD,len(YOURFIELD)-index(YOURFIELD,' ',2))

Hope this helps,

Stefan

erichshiino — Wed, 16 Nov 2011 14:08:00 GMT

HI,

if A, B, C, etc are field values, you can build a list with the following expression (field is F1)

=AGGR(ONLY({<F1={C,D,E}>} F1),F1)

You can check it working in the attachment.

Regards,

Erich

swuehl — Wed, 16 Nov 2011 14:13:39 GMT

Ah, I missed that you wanted only the middle part, sorry.

So if you are having some kind of string containing the hierarchy levels, maybe like this:

=mid('A B C D E F G H',index('A B C D E F G H',' ',2)+1,index('A B C D E F G H',' ',6)-index('A B C D E F G H',' ',2))

christophebrault — Thu, 17 Nov 2011 08:33:08 GMT

That's exactly what i wanted.

Thanks a lot,