Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
WernerDC
New Contributor II

Match Function

Hi,

I have this following head scratchier

I have fields in my data I want to rename.

For example:

From

C:/QV/QVDEPLOY/LIVE/APP IB 004 - PACKHOUSE ANALYSIS/WAGES - STEENEBRUG/APP IB 004 - FARM ANALYSIS (STEENEBRUG - 90 BESIG MET G).QVW

To

Steenebrug Farm Analysis

 

This is an App where I created App logs so my users can see how people in the company are using the Apps.

So the issue is that my App (as showed above) is shown so big. 

Attached are 2 snips of what my issues are.

1. In the App the name shows to big

2. Is where I bring in the name

Labels (1)
2 Solutions

Accepted Solutions

Re: Match Function

May be all you need is a ApplyMap here

Re: Match Function

Create Inline Table which will contain two field
1: existing app Name
2: New App Name (which you want to show)

Note reduce app Name which you are getting use subfield() to capture only app Name instead of app name with full path
like (SubField(Document),'/',-1) as session_app_name

Regards,
Great dreamer's dreams never fulfilled, they are always transcended.
4 Replies

Re: Match Function

May be all you need is a ApplyMap here

WernerDC
New Contributor II

Re: Match Function

So should I create a table with all the new names I want?

Can you maybe show me an example?

Upper(Document) as [SESSIONS APP NAME], (This is the column with all the App names.In the script)

C:/QV/QVDEPLOY/LIVE/APP IB 004 - PACKHOUSE ANALYSIS/WAGES - STEENEBRUG/APP IB 004 - FARM ANALYSIS (STEENEBRUG - 90 BESIG MET G).QVW (This is a Typical App name)

Steenebrug - Packhouse (This the name I want to give it.)

Kind regards

 

Re: Match Function

I am happy to share a sample if you are able to share some raw data in Excel format for me to load.

Re: Match Function

Create Inline Table which will contain two field
1: existing app Name
2: New App Name (which you want to show)

Note reduce app Name which you are getting use subfield() to capture only app Name instead of app name with full path
like (SubField(Document),'/',-1) as session_app_name

Regards,
Great dreamer's dreams never fulfilled, they are always transcended.