Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
akpofureenughwu
Contributor 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
Valued Contributor III

Re: Character Recognition System

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
Contributor III

Re: Character Recognition System

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
Valued Contributor III

Re: Character Recognition System

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
Contributor III

Re: Character Recognition System

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