Discussion board where members can get started with QlikView.
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
Try: left([Key Individual], 1) & '-' & subfield([Key Individual], '-', 2)