Discussion board where members can get started with Qlik Sense.
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.
Go to 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, ratingFROM [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.