topic reading log file, Alias name in QlikView

reading log file, Alias name

everest226 — Wed, 04 Jan 2017 20:57:52 GMT

I have apps which ready log file from server , basically it reads all dashboard usage and user,

the following script reads all the apps name , is it possible to change different document name as alias.

market.qvw as marketing Dashboard

Sales_qvw as Sales Dashboard.

script which reads document name

Lower(Mid(Document,Index(Document,'\',-1)+1)) as QVWName,

sunny_talwar — Wed, 04 Jan 2017 22:01:58 GMT

You want to create multiple fields? or QVWName should contain marketing Dashboard, Sales Dashboard instead of market.qvw or Sales.qvw?

everest226 — Wed, 04 Jan 2017 22:12:03 GMT

Hi Sunny thanks for reply ,

only one Field is QVWName ,

in that listbox there are all the dashboard name that i want to change

market.qvw as marketing Dashboard

Sales_qvw as Sales Dashboard.

sunny_talwar — Wed, 04 Jan 2017 22:14:35 GMT

May be you can use Map SubString here:

MappingTable:

Mapping

LOAD * INLINE [

QVWName, NewQVWName

.qvw, " Dashboard"

];

MapSubString('MappingTable', Lower(Mid(Document,Index(Document,'\',-1)+1))) as QVWName,

sunny_talwar — Wed, 04 Jan 2017 22:15:18 GMT

Or you can just to

Replace(Lower(Mid(Document,Index(Document,'\',-1)+1)), '.qvw', ' Dashboard') as QVWName

everest226 — Wed, 04 Jan 2017 22:25:51 GMT

here is the attachment,

apps is qvw name,

research- testing as research for all group

research-validation as researcher for validation only

sales.qvw as Sales

all those are coming from this script

Lower(Mid(Document,Index(Document,'\',-1)+1))) as QVWName,

everest226 — Mon, 09 Jan 2017 21:14:20 GMT

Thanks stalwar1‌ it worked out perfectly