Discussion board where members can get started with Qlik Sense.
How can i load my data to get below result?
Initial field: "Id No"
I want to separate it into 2 field. "Id No" and "Version". Please help. Thanks.
Go to Solution.
Subfield("Id No",'_',2) AS [Id No],
Subfield("Id No",'_',3) AS Version
You should be able to do the following:
Right("Id No",1) AS Version
Hope that helps.
Thanks Thiago. it works as expected.