Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Renaming Field Values

I have the following load script:

QVDTOCProfitCenter:

LOAD

PROFIT_CTR.PROFIT_CTR as [TOCLOC],

PROFIT_CTR.TXTMD as [TOC Location]

FROM

[$(vLoadpath2)PROFIT_CTR.qvd]

(qvd)

Where exists ([TOCLOC], [PROFIT_CTR.PROFIT_CTR])

and PROFIT_CTR.CO_AREA = 'HOL'

and PROFIT_CTR.LANGU = 'E'

and PROFIT_CTR.DATETO > Today() and

PROFIT_CTR.DATEFROM <= Today();

This load gives me identical names for different PC ID's. How can I override these field names? In other words, for ID# 5555 I want to name it 'Field Value 1' and for 5556 I want 'Field Value 2', instead of 5555 and 5556 both named the same.

3 Replies
Highlighted
Champion III
Champion III

Re: Renaming Field Values

Is your Field ID# a fieldname which has values like 5555, 5556? How many values you have to change? You can use a pick(Match()) or a Mapping table. Give us some more info to help you.

Highlighted
Contributor
Contributor

Re: Renaming Field Values

Yes, [TOCLOC] is the field ID# which has values like 5555, 5556. I have two [TOCLOC] ID #s that have the same [TOC Location] name. It is the [TOC Location] name that I want to modify.

Highlighted
Champion III
Champion III

Re: Renaming Field Values

I am confused, would you mind posting some sample data with your expected output so that we can figure it out?