topic Space in fields within Data Island in QlikView

Space in fields within Data Island

Thu, 26 Apr 2012 11:40:53 GMT

Hi All,

I would appreciate if someone could help please.

I have a data island created from another filed:

Comparison_TradingG:

LOAD

TRADING_GROUP_DESCRIPTION as Comparison_TradingG,

Resident CIRR_MEASURES_WITH_DETAILS;

But the problem is the fileds with this table has spaces in the names and i am not shure how to trim these, as there is no data showing in my expresions.

Regards,

Redha

Space in fields within Data Island

Jason_Michaelides — Thu, 26 Apr 2012 11:42:59 GMT

Maybe try:

Comparison_TradingG:

LOAD

PurgeChar(TRADING_GROUP_DESCRIPTION,' ') as Comparison_TradingG,

Resident CIRR_MEASURES_WITH_DETAILS;

Hope this helps,

Jason

Space in fields within Data Island

Thu, 26 Apr 2012 12:52:29 GMT

Hi,

It gives a red line under like this:

Resident CIRR_MEASURES_WITH_DETAILS;

Redha

Space in fields within Data Island

CELAMBARASAN — Thu, 26 Apr 2012 12:54:37 GMT

Hi,

Can you post that full load script of that particular table?

Celambarasan

Re: Space in fields within Data Island

Miguel_Angel_Baeyens — Thu, 26 Apr 2012 12:58:13 GMT

Hi Redha,

There is a trailing comma that what is causing the error:

Comparison_TradingG:
LOAD
Trim(PurgeChar(TRADING_GROUP_DESCRIPTION, ' ')) as Comparison_TradingG // no trailing comma here
RESIDENT CIRR_MEASURES_WITH_DETAILS;

Hope that helps.

Miguel

Space in fields within Data Island

Thu, 26 Apr 2012 13:20:07 GMT

Hi,

Thank you for your help as it did work perfect.

I wounder if you can help in something else?

When I select one filed from the data islnad is fine but when I have a multiple selection it doesn't.

I had added this as a Varaible =CHR(39)&CONCAT(Comparison_TradingG,CHR(39)&','&CHR(39))&CHR(39)

it works but very slow.

is there a diffrent way to get the data island to calculate accourding to whats selected, I mean multiple selection?

Regards,

Redha

Space in fields within Data Island

CELAMBARASAN — Thu, 26 Apr 2012 13:28:45 GMT

Hi,

Check with this

=if(GetSelectedCount(Comparison_TradingG)>0,CHR(39)&CONCAT(DISTINCT Comparison_TradingG,CHR(39)&','&CHR(39))&CHR(39),'*')

Celambarasan

Space in fields within Data Island

Thu, 26 Apr 2012 15:45:47 GMT

Hi,

Thank you that worked perfectly.

Redha