Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
See attached example
Can you please post content or equations in file attached.because i am using qliksense Tool.
Thanks,
Supriya R
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);