Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am new to qlikview and I am trying to create a field from another field that says if this field starts with "2" then display the information as is but if not only show the first 12 characters.
any advice please
One way is as below:
Data:
Load * Inline [
ID,Type
10,2 First Record data
20,Second record sample data
30,Third record sample data
40,2 Fourth Record Data
50,Fifth record sample data
];
SourceData:
Load ID,
If(Left(Type,1)=2,Type,Left(Type,12)) as Type
Resident Data;
One way is as below:
Data:
Load * Inline [
ID,Type
10,2 First Record data
20,Second record sample data
30,Third record sample data
40,2 Fourth Record Data
50,Fifth record sample data
];
SourceData:
Load ID,
If(Left(Type,1)=2,Type,Left(Type,12)) as Type
Resident Data;
Thank you
You are welcome...