Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

What is the expression to be used in making some reasons for " Late visit".

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

9 Replies
nevilledhamsiri
Specialist
Specialist
Author

Dear!

Please help!

I need those reasons to be continued to be shown in a single column

Regds

Neville

DavidŠtorek
Creator III
Creator III

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

nevilledhamsiri
Specialist
Specialist
Author

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

nevilledhamsiri
Specialist
Specialist
Author

Please look in to this.

Regds

Neville

nevilledhamsiri
Specialist
Specialist
Author

Dear All!

Please see to this.

Best Regards

Neville

DavidŠtorek
Creator III
Creator III

Hi,

  1. Ad one more row to load script to your current table with some unique ID eg Hash160 ("Date / Month..." (whatewer date is for planned visit) , "Person assigned for Visit" , "Branch to be visited") as ID
  2. Create sheet with table with late visits. It should have columns ID, Branch to be visited Planned_Month, Person Assigned for Visit Type of Visit. (You can format ID column text with white color in order not to disturb)
  3. Export this table into excel (do it yourself). Save it in some folder where others has access to and from where will Qlik load it
  4. Open Exported excel and add column for Reason. Let it all blank.
  5. Add additional table to your load script and load it. Something like that

LOAD Distinct

    ID,

    Reason

FROM [lib://<your path>/*.xlsx]

(ooxml, embedded labels, table is Sheet1)

where Reason<>'-';

  1. Go back to sheet with table you previously exported and add new column Reason here.
  2. Instruct people to export it (table) if they are supposed to fill reason. Tell them change nothing but fill in their reason and save this excel to location you choose.
  3. That is it.
nevilledhamsiri
Specialist
Specialist
Author

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

DavidŠtorek
Creator III
Creator III

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?

nevilledhamsiri
Specialist
Specialist
Author

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