SUBFIELD Function Problems

[#1]

Hello,

The below script runs all right when the application is reloaded with de CTRL+R on the developer IDE, but when scheduled on a trigger and reloaded automatically by the server the column 'equipe_responsavel' returns all values with null instead of the right result, anyone can help me? I've tried to reload only this table, and the result is always the same

[TESTE]:

  LOAD

  nmequiperesponsavel,

SUBFIELD(nmequiperesponsavel,',') AS 'equipe_responsavel';

  SELECT DISTINCT

    nmequiperesponsavel

FROM vw_sel_tickets_cw;

[#2]

This is what i get when i reload:

manual.bmp (attached)

And this is what i get when server reload:

server.bmp (attached)

Is the same script, the same QVW file, there is only this table on the this QVW and olny this little script that i posted.

[#3]

Jonathan Dienst & Chris Conejero

[#4]

Yes it works!

[Anonymous]

Looks like a bug.  Maybe related to the special characters.

Try this, with simple characters:

[TESTE]:

  LOAD

  nmequiperesponsavel,

SUBFIELD(nmequiperesponsavel,',') AS equipe_responsavel;

LOAD * INLINE [

    nmequiperesponsavel

    "A,B,C"

   "E,F,G"

];

[#6]

It gets the same problem! Could it be any configuration on my QVW file ?

[Anonymous]

I tried this (attached) on Desktop and on QVS (Publisher), works in both cases.
If it works for you in Desktop but not in QVS, something isn't quite right in QVS configuration, but nothing's wrong with this QVW.

[#8]

Loading on a tmp table doesn't work too... 

SELECT distinct

    nmequiperesponsavel

    into #tmp_teste

FROM [vw_sel_tickets_cw] ;

    [EXPLODE_EQUIPE]:

  LOAD DISTINCT

  nmequiperesponsavel,

  LTRIM(RTRIM(SUBFIELD(nmequiperesponsavel,','))) AS 'equipe_responsavel';

   SELECT *

FROM #tmp_teste ;

[#9]

Thanks, but it doesn't work too...

Run ok on the Desktop, but not on Server...

I'm using QlikView 9.00, could it be a bug?

[#10]

Thanks everyone, but this is taking a lot o my time. I'll build this function on SQL Server or just use SUBFIELD on the chart expresssions instead of load script.

Thanks a lot!

[rwunderlich · Accepted solution]

Yes, it probably is a bug. There was that exact bug on V9 SR7 -- two parm subfield returns nulls. I suspect you are using SR7 on the server and a different build on the desktop.

-Rob

http://masterssummit.com