topic Re: Character Recognition System in QlikView

Character Recognition System

akpofureenughwu — Wed, 25 Nov 2020 16:16:04 GMT

Good day everyone,

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

S/N	Project Name	Cost	Remark	Status
1	Installation of Lights	$3,000	Community issues to be resolved. 70% completed	On-going
2	Sound Check Test	$500	100%	Complete
3	Construction of Civic Centre	$34,000	Work completed but yet to be paid.	Complete
4	Design of Post	$210	Retention 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

Re: Character Recognition System

olivierrobin — Tue, 06 Mar 2018 15:53:26 GMT

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

Re: Character Recognition System

akpofureenughwu — Wed, 07 Mar 2018 12:06:09 GMT

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

roharoha‌ stalwar1‌ ivan.bozov‌ Can you share your thoughts on this?

Re: Character Recognition System

olivierrobin — Wed, 07 Mar 2018 12:11:06 GMT

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

Re: Character Recognition System

akpofureenughwu — Wed, 07 Mar 2018 12:27:58 GMT

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