Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alias for values in Column

Hi All,

I have a requirement like i want to do alias for values in a particular Column and my source is Excel sheet

say for example

Column Name is Key Individual and the values are Hospital-KI and IDN -KI . Now i want to do alias these values like H-KI and I-KI in this Column at Script level.

How to achieve this

Thanks in Advance

Reddi Kishor

Happy Viewing

1 Reply
MVP & Luminary
MVP & Luminary

Re: Alias for values in Column

Try: left([Key Individual], 1) & '-' & subfield([Key Individual], '-', 2)

- Marcus