topic INDEX, substring, mid , trim ,left , right in QlikView

INDEX, substring, mid , trim ,left , right

Tue, 26 Mar 2013 07:11:13 GMT

Hi guys,

I need to represent TOTAL NO oF VIEWS for a WEBPAGE as dimension. Since the webpage name is a Http:// ....................................................

type of string, it takes a lot of space on teh chart and does not display properly.

How can i use correct string function to display only the last part of the page link??

e.g if i have a page link as https://portal.abcd/strategy/pages/depot/abcd/page/home.aspx

and . https://portal.abcd/strategy/pages/depot/abcd/page/webcommunication.aspx

which i want to display as only Home

only as webCommunication respectively on my chart x axis.

Please let me know how a correct string function can be applied on the field Page during Load.

Thanks!

Re: INDEX, substring, mid , trim ,left , right

kaushiknsolanki — Tue, 26 Mar 2013 07:23:40 GMT

Hi,

Try this code

Load Page,mid(Page,Index(Page,'/',len(KeepChar(Page,'/')))+1,Len(Page)-Index(Page,'/',len(KeepChar(Page,'/')))-5) as ABC inline [
Page
https://portal.abcd/strategy/pages/depot/abcd/page/home.aspx
https://portal.abcd/strategy/pages/depot/abcd/page/webcommunication.aspx
];

Have a look at the attched example.

Regards,

Kaushik Solanki

Re: INDEX, substring, mid , trim ,left , right

Tue, 26 Mar 2013 09:34:44 GMT

Thanks Kaushik.