topic Re: Need to capture only Text value in List box in QlikView

Need to capture only Text value in List box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a list box which has both "Integer" and "Text" items. I need to capture only "Text" and need to ignore "Integer" from the list. Thanks in advance.

Re: Need to capture only Text value in List box

tamilarasu — Thu, 16 Jun 2016 13:17:32 GMT

You can try below expression,

If(IsText(Left(FieldName,1)), FieldName)

Re: Need to capture only Text value in List box

sunny_talwar — Thu, 16 Jun 2016 13:18:39 GMT

May be like this in the script:

Where IsText(FieldName);

or this in the front end list box expression:

If(IsText(FieldName), FieldName)

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 13:21:07 GMT

Something like this?

PurgeChar and KeepChar Functions

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 13:30:37 GMT

Hi Sunny & Tamil,

Thanks for your help. But once I include the "where" condition in the script, I am getting only "Text" which is correct. But, I am losing my Blank rows. Attached screen shot for your reference. Sry for troubling u. ! !

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 13:35:57 GMT

Hi Balraj,

Basically I am having Columns with Integer, Text and NULL values. In my front end, I need to capture only Text and NULL values and need to ignore integer values. Above suggestion given by Sunny is working fine, where I am getting only TEXT values but my NULL value (Empty cell) is lost. The link which u shared is different I guess so. Thanks in advance Balraj.

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 13:41:48 GMT

Hi Tamil,

Thanks for you Quick reply. I implemented u r formula, But it is duplicating the column values. Attached screen shot for your reference.

Re: Need to capture only Text value in List box

sunny_talwar — Thu, 16 Jun 2016 13:56:34 GMT

Try this may be

Where IsText(FieldName) or Len(Trim(FieldName)) = 0;

Re: Need to capture only Text value in List box

sunny_talwar — Thu, 16 Jun 2016 13:57:49 GMT

Check this:

NULLASVALUE *;

SET NullValue = ' ';

Directory;

LOAD Name,

Department,

[Arrival Place],

[Departure Place],

[Arrival Time],

[Departure Time],

[Total Journey Hours],

Amount,

[Booking Date]

FROM

Example1.xlsx

(ooxml, embedded labels, table is Sheet1)

where IsText([Arrival Place]) or Len(Trim([Arrival Place])) = 0;

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 14:01:39 GMT

Perfect Sunny, Thanks a lot, Checked the above script and working fine.

Re: Need to capture only Text value in List box

tamilarasu — Thu, 16 Jun 2016 14:13:56 GMT

RubanDoss,

Sunny is too fast.You can use his solution.

Re: Need to capture only Text value in List box

Anonymous — Thu, 16 Jun 2016 14:20:02 GMT

Ha ha ha. Still u helped me Tamil. Thanks for u r reply.

Re: Need to capture only Text value in List box

tamilarasu — Thu, 16 Jun 2016 16:16:19 GMT

RubanDoss,

Please mark Sunny's answer as correct and close the thread. It might helps others.