2 Replies Latest reply: Nov 2, 2016 6:49 PM by Marco Wedel RSS

    Substr and Instr in Qlikview?

      Having a tough time translating this SQL function to work as a load in Qlikview:

      lower(substr(EMAIL_ADDRESS,instr(EMAIL_ADDRESS,'@'),length(EMAIL_ADDRESS))) "Email Domain"


      essentially I'm loading just the @xxxxx.xxx of the email.


      Any help would be greatly appreciated, thanks!