Hello to you all out there!
I want to make a graph from a txt log file that is being updated every 5 minutes.
First of all how do I import the txt file and make seperate tables of the contents ( I attathed the TXT file).
Then I want to use a Stoplight Graph then will show green when there is nothing in the TXT file, Yellow when there are 2 Aircrafts in the TXT file, RED when their are 5 or more Aircrafts in the TXT File.
I am a QlikView Noob, but i am happy to get to know it better since i noticed it is a Power Application. If i get this to work I'll implement it in our Network,
but for now i am using the Personal Edition!
Any tips and ideas are appreciated!
This is how the contents look like:
fn_carrier ac_registr sched_offb_dep_date sched_offb_dep_time sched_onbl_arr_date sched_onbl_arr_time
---------- ---------- ------------------- ------------------- ------------------- -------------------
EXM KZA 14227 60 14227 630
RP KZO 14225 450 14227 781
RP KZV 14224 540 14227 541
EXM KZA 14227 60 14227 541
AOG KZK 14227 750 14227 936
AOG OFN 14227 314 14227 961
AOG KZM 14221 1410 14227 541
EXM KZE 14227 300 14227 360
AOG EZH 14227 525 14227 661
AOG OFO 14227 325 14227 480
EXM KZA 14227 60 14227 121
AOG OFO 14227 325 14227 1081
EXM KZA 14227 60 14227 633
EXM KZA 14227 60 14227 633
AOG KZK 14227 645 14227 721
AOG KZK 14227 990 14227 1176
AOG OFO 14227 325 14227 600
AOG OFO 14227 325 14227 661
AOG KZK 14227 415 14227 481
AOG KZK 14227 415 14227 601
AOG OFO 14227 325 14227 1021
AOG OFO 14227 325 14227 690
AOG OFM 14226 870 14227 61
EXM KZA 14227 60 14227 360
EXM KZA 14227 60 14227 721
EXM KZE 14227 300 14227 360
AOG EZB 14227 315 14227 345
AOG KZU 14226 720 14227 61
AOG KZK 14227 315 14227 330
AOG KZK 14227 315 14227 601
RP KZV 14224 540 14227 721
AOG OFO 14227 325 14227 361
AOG OFO 14227 325 14227 361
AOG OFO 14227 325 14227 390
AOG KZM 14221 1410 14227 1321
AOG OFO 14227 325 14227 420
AOG OFN 14227 314 14227 421
AOG OFN 14227 314 14227 391
(38 rows affected)
