topic Re: Match Function in QlikView

Match Function

WernerDC — Sat, 16 Nov 2024 03:53:08 GMT

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

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

Re: Match Function

sunny_talwar — Thu, 11 Apr 2019 20:14:55 GMT

May be all you need is a ApplyMap here

Re: Match Function

WernerDC — Fri, 12 Apr 2019 05:29:24 GMT

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

sunny_talwar — Fri, 12 Apr 2019 11:22:56 GMT

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

PrashantSangle — Fri, 12 Apr 2019 11:51:47 GMT

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,