Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Character Recognition System

Good day everyone,

I have a list of project I need to visualize on Qlik. Below is the sample data

S/NProject NameCostRemarkStatus
1Installation of Lights$3,000Community issues to be resolved. 70% completedOn-going
2Sound Check Test$500100% Complete
3Construction of Civic Centre$34,000Work completed but yet to be paid.

Complete

4Design of Post$210Retention outstanding.Pending

      

I will need a script that will run those the Remark column and produce an output in the Status column.

In the above table, the script is in check row 1.... since there is a 70% complete string, it will produce an output 'on-going' in status column

Thank you for your time.

Regards

4 Replies
olivierrobin
Specialist III
Specialist III

hello

how do you determine the value of status ?

if remark is a list of text, you can use an applymap based on the text

akpofureenughwu
Creator III
Creator III
Author

Hello olivierrobin

The value of status is based on the content of remark column.

I am currently using a join statement for that..  Read the Status from a load *line table

But I think there is a smarter way of doing this

i.e from the main project table,

The script will read through the remark table and generate the status

for example   Remark holds 'FIXING OF THE 4TH TANK. 90% COMPLETED'

                      Status shows On going

                      remark holds '100%'

                      Status shows  Complete

roharohastalwar1ivan.bozov‌  Can you share your thoughts on this?

olivierrobin
Specialist III
Specialist III

hello

if you have somewhere the correspondancy between remark and status, you can achieve this by a left join from the main table and the correspondancy table

akpofureenughwu
Creator III
Creator III
Author

Olivier,

I am currently using a left join statement. I just look for other smarter options (more like a wildcard compare option).  Why I seek a smarter option is because of the data capture end, the user enter their remarks on a text field so they might input lots of word so I want to script that will be smart to detect keywords and output an appropriate status.

Thank you Olivier

Regards