topic Connecting visitors to date & hour in App Development

Connecting visitors to date & hour

Tue, 12 Jan 2016 08:04:08 GMT

Hi guys,

I wanted to try something new, but don't really know where to start and how to do things. I have many files that look like this.

What I want to do is to somehow connect visitors to date and hour. I have a customers table with customer orderID as the key.

1. It is reasonable to make a left join to that table, isn't it?

2. How do I handle that fact that there are many tables like this (1 for each month)? How can I load them into the script without there being 50 tables?

3. How would I visualize this in the best way later on?

I'm aware that there are a great deal of questions, but I'm hoping that someone can share their knowledge 😃

Re: Connecting visitors to date & hour

Tue, 12 Jan 2016 08:25:18 GMT

Okay, so I think I managed to answer question 2. I concatenated the tables into one and I'm guessing it's the right way to do it? (this is my first time I do it =D).

Sincerely,

Betty Habtemariam

Re: Connecting visitors to date & hour

Tue, 12 Jan 2016 08:35:26 GMT

Ignore question 1 as well. Maybe it's not a good idea to do a left join...?

Sincerely,

Betty Habtemariam

Re: Connecting visitors to date & hour

reddy-s — Tue, 12 Jan 2016 18:36:19 GMT

Hi Betty,

As you have figured out the solution for the 1st and 2nd questions , check the below link in QlikBranch:

Time line extension : http://branch.qlik.com/#/project/56728f52d1e497241ae6989d

Thanks,

Sangram