topic Re: Urgent Help needed for list box in QlikView

Urgent Help needed for list box

Fri, 08 Feb 2013 16:48:32 GMT

Hi All,

I have loaded two fields from qvd i.e., Brand and Short_desc. If Brand is null or space then it is renamed as 'Unknown' but for 'Unknown' Brand there is no Short_desc.

IF (len(Brand)<=11,Brand,mid(Brand,11)) as Brand_TXTSH

Here problem is why Brand_TXTSH is not having value 'Unknown'?

In a list box i need to display Brand_TXTSH&'-'&Short_Desc.

Brand	Short description_TXTSH	Brand_TXTSH
CA001MGS060206001	Bystolic	0206001
FI001	Forest Ireland	FI001
FI001MGS10CELEXA	Celexa	CELEXA
FI001MGS99OTHDIREC	Other Direct	OTHDIREC
FI001MGS060206001	Bystolic	0206001
FI001MGS090210001	Teflaro	0210001
FI001MGS131001001	Namenda	1001001
FI001MGS210907003	Savella	0907003
Unknown

Pl help..

Re: Urgent Help needed for list box

sbaldwin — Fri, 08 Feb 2013 17:01:47 GMT

Hi without seeing the load script i couldnt say for should but looking at what you have done, the Brand field in the QVD you are renaming while loading but in the if statement above you are evaluating the source Brand field in the qvd (which is blank!), either apply the condition to the source field or do a preceeding load on the "amended" Brand field.

Thanks

Steve

Re: Urgent Help needed for list box

nagaiank — Fri, 08 Feb 2013 17:13:14 GMT

You may try the following:

IF (len(Trim(Brand))<=11,Brand,mid(Brand,11)) as Brand_TXTSH