Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nazaninslp
Contributor III
Contributor III

rename fields of list box in expression

Dears

I write below expression for my list box , the issue is that I want to rename some of my fields name.

how can it possible to change them in expression directly?

expression : 

=if(Match(Area_Category,'DCB','EServices','EB','Game','Lifestyle','Money_Collection','Sport','Streaming','Traditial'),Area_Category)

Items that I want to

change:

'DB' >>> 'DEDICATED C'

'Money_collection' >> 'M Col'

 

 

Labels (2)
3 Replies
thiago_justen
Specialist III
Specialist III

You can create a synthetic dimension using ValueList ().

 

For instance: ValueList('DEDICATED C','EServices','EB','Game','Lifestyle','M Col','Sport','Streaming','Traditial')

 

The problem here is that you have to apply valuelist in your expressions too.

 

You could also use Replace() function. I guess it's better option than above one. For example: Creating a master dimension like this:

If(Match(Area_Category,'DCB'),Replace(Area_Category,'DCB','DEDICATED C'),Area_Category)

 

But, of course, you strongly recommend you replace field value while scripting. Then you can use Mapping table and so on.

 

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
robin_heijt
Creator
Creator

This should work (Copy paste as 1 expression):
if(Area_Category='DCB','DEDICATED C',
if(Area_Category='EServices','EServices',
if(Area_Category='EB','EB',
if(Area_Category='Game','Game',
if(Area_Category='Lifestyle','Lifestyle',
if(Area_Category='Money_Collection','M COL',
if(Area_Category='Sport','Sport',
if(Area_Category='Streaming','Streaming',
if(Area_Category='Traditial','Traditial')))))))))
sarahcl
Contributor II
Contributor II

Works perfectly! Thank you!