Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As stated above can some one help me to add the reason for not visit. This should be combined with Month, Person assigned for visit,type of visit etc.Every month if there is a late visit by some one, the reason for the same needs to be given. Cans some one suggest for an expression. Also please suggest where & how the reasons for late visits to be presented. Should it be as an variable or otherwise
Regds
Neville
Dear!
Please help!
I need those reasons to be continued to be shown in a single column
Regds
Neville
Hi,
If I understand your question correctly, you want to have a reason for Late visits. Does the reason have to be replenished by the person assigned to the given visit? And the person should to find out from Qlik? If so, I recommend creating a table on a single sheet that would only list "Late Visit", and the person would have exported to Excel and filled the reason for the late visit. Excel would be stored in a folder from which qlik would read it and based on an ID (eg Hash128 ("Date / Month" & "Person assigned for Visit" & "Branch to be visited") as ID ) then the reason will be added to the original table.
Users can filter table just for their records and export only their own. Or tell them not to filter and you can load only newest file..its up to yours discretion
For loading of table with reasons use something like that:
LOAD
ID,
Reason
FROM [lib://<your path>/*.xlsx]
(ooxml, embedded labels, table is Sheet1)
where Reason<>'-';
I hope it helps
Hi
David,
Thanks for your time in responding!. I cannot exactly grasp where & how this is done. You mean after data being loaded & then export it to excel & then assign an ID for different people using an additional column & mention the reason in another column etc. After that load that table again......
Following renaming bit confusing me may be I am not that conversant. Please explain with an example with relevant steps to be followed.
eg Hash128 ("Date / Month" & "Person assigned for Visit" & "Branch to be visited") as ID ) then the reason will be added to the original table.
Could you please write this in a note pad & send me. I am using a personnel edition. I was away from my home that was why the delay in responding.
Regds
Neville
Please look in to this.
Regds
Neville
Dear All!
Please see to this.
Best Regards
Neville
Hi,
LOAD Distinct
ID,
Reason
FROM [lib://<your path>/*.xlsx]
(ooxml, embedded labels, table is Sheet1)
where Reason<>'-';
Hi David,
You have done a lot but I still cannot understand where & how this cold be done.If you could do this on my sample data & send me your working that will be fine.
Thanks
neville
Hi,
Maybe I do not quite understand what you're up to. Is it your goal to make sure that someone who had a late visit somewhere filled the reason why he was late and this reason to show you in Qlik?
Yes David
But the steps you have given there looks somewhat difficult to understand. If you don't mind can you please enter some sample reasons & show me the steps you did in a note pad. May be what you suggest is what I need to have but the issue is the places & the way those steps are done looks little difficult to understand. Sorry for the troubles!
Neville