topic Re: Subfield() function problem in QlikView

Subfield() function problem

Tue, 15 Sep 2015 17:32:19 GMT

Hi,

I have a list box containing values with comma(s) and without comma. I would like to show all distinct values in that list box.

When I used subfield() function, it shows value which is not there in the available choices. Looks like something weird happening. Please see a snap shot below:

Picture on the left is what I have, picture on the right is the outcome of the following expression.

=if(Index(UseCase,',') <> 0,Trim(SubField(UseCase,',')),Trim(UseCase))

I would like to see the following result:

Data Center Consolidation

Disaster Recovery

Partial Environment Consolidation

Any help is appreciated.

Thank you,

Parth

Re: Subfield() function problem

Clever_Anjos — Tue, 15 Sep 2015 17:40:31 GMT

You should create a field at script level and use it into your listbox

Re: Subfield() function problem

MK_QSL — Tue, 15 Sep 2015 18:12:20 GMT

Use

SubField(UseCase,',') as UseCase

at script level.

Re: Subfield() function problem

Tue, 15 Sep 2015 18:19:04 GMT

Thank you. It worked. Have a good one.

Regards,

Parth Shah.

Re: Subfield() function problem

Tue, 15 Sep 2015 18:19:12 GMT

Thank you. It worked. Have a good one.

Regards,

Parth Shah.