Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUBFIELD Function Problems

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;

23 Replies
Anonymous
Not applicable
Author

Thanks Rob, now it makes sense.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Not that my memory is that good I just recalled encountering and reporting that bug and found it in my emails from March 2011.

-Rob

Not applicable
Author

Anonymous
Not applicable
Author

It's pretty good if you ask me.

(Apparently it helps to have last name starting with W - Wassenaar, Wuehl, Wiherspoon...  )