Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
subfield(path,'\',1) returns an empty string as there is nothing before the first backslash.
Try:
subfield(path,'\',-1)
Try like below
=subfield('\\qlikview\qliktech\dashboard','\',5)
Regards
ASHFAQ
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
subfield(path,'\',1) returns an empty string as there is nothing before the first backslash.