Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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
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