Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Displaying last number of each row in column

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.

1 Solution

Accepted Solutions

Re: Displaying last number of each row in column

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);

3 Replies

Re: Displaying last number of each row in column

See attached example

berryandcherry6
Contributor II

Re: Displaying last number of each row in column

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

Thanks,

Supriya R

Re: Displaying last number of each row in column

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);