Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Connecting visitors to date & hour

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.

Connecting visitors to hour and time.PNG

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 =)

3 Replies
Not applicable

Re: Connecting visitors to date & hour

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

Not applicable

Re: Connecting visitors to date & hour

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

Sincerely,

Betty Habtemariam

reddys310
Honored Contributor II

Re: Connecting visitors to date & hour

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

Screen Shot 2016-01-12 at 6.35.34 PM.png

Thanks,

Sangram