Displaying last number of each row in column

[berryandcherry6]

I want to display  last number in the last_accessed_page as dimension in x-axis, Where version should be 'v2' .If numbers in rows of  last_accessed_page is 1,1,7 i want it to display 7 in x-axis.

How could i do this.Any help is appreciated.I have attached csv file of database.

[Gysbert_Wassenaar]

See attached example

[berryandcherry6]

Can you please post content or equations in file attached.because i am using qliksense Tool.

Thanks,

Supriya R

[Gysbert_Wassenaar · Accepted solution]

Sure. Try this script:

subject_access_track_id,
    subject_id,
    subject_name,
    user_id,
    client_id,
    client_name,
    lender_offer_id,
    suspend_data,
    subject_status,
    subject_start_date,
    subject_completed_date,
    total_time_taken,
    last_accessed_page,
    if(version='v2' , SubField(last_accessed_page,',',-1)) as final_page,
    requires_pretest,
    version,
    sitting_status,
    percentage_completed,
    rating
FROM
    [LIB://MyFolder/subjectaccesstracking.csv]
    (txt, codepage is 1252, embedded labels, delimiter is ',', msq);