topic Re: string fun ? in QlikView

string fun ?

Anonymous — Mon, 08 Dec 2014 07:45:00 GMT

path:

\\qlikview\qliktech\dashboard

i have used subfield function here like

subfield(path,'\',1) ? what is output ?

i want my subfield fun return has dashboard ? what to do ? how to do?

tresB — Mon, 08 Dec 2014 07:52:02 GMT

Try:

subfield(path,'\',-1)

ashfaq_haseeb — Mon, 08 Dec 2014 07:55:26 GMT

Try like below

=subfield('\\qlikview\qliktech\dashboard','\',5)

Regards

ASHFAQ

its_anandrjs — Mon, 08 Dec 2014 08:38:37 GMT

Try some of this

This return qlikview

=subfield('\\qlikview\qliktech\dashboard','\',3)

This return qliktech

=subfield('\\qlikview\qliktech\dashboard','\',4)

This return dashboard

=subfield('\\qlikview\qliktech\dashboard','\',5)

Regards

Anand

MarcoWedel — Mon, 08 Dec 2014 08:53:09 GMT

subfield(path,'\',1) returns an empty string as there is nothing before the first backslash.