Discussion Board for collaboration on QlikView Scripting.
I have export my task list from Any.do app , my question is how to make use of QV to read the raw data ? in my next posting i will post the raw data text file.
Go to Solution.
Just Add RecNo(), in the script..
Directory;Any_Do_App:LOAD @1 as Any_Do_App,
RecNo() as RowNumberFROM[File 25-2-16, 10 47 09 - Copy.txt](txt, utf8, no labels, delimiter is '\t', msq);
my Raw Data Txt file
The data seems rather unstructured but they could be loaded - you will need some logic to make sense of them.
I think the below one will give the required result. Just I load the file Delimiter as Tab using the Transformation Wizard.
Directory; Any_Do_App: LOAD @1 as Any_Do_App FROM [File 25-2-16, 10 47 09 - Copy.txt] (txt, utf8, no labels, delimiter is '\t', msq);
Any idea how can i list all the task and count number of row ? so i know how many row in my table ?
Thank you very much.
You are right , the table missing one dimension,
look like the dimension missing. for example task on urgent have 50 task,
So unable to make analysis.
Would you mind to close this thread by marking Correct or Helpful answers.!!