travel date data problem

[adiarnon]

hi,

i have a table of travels

employee	city	from date	to date
a	paris	1/1/14	6/1/14
b	new york	2/1/14	5/1/14
c	tel aviv	4/1/14	20/1/14
d	london	1/1/14	1/2/14

i want to create a bar chart thant on the x axis i will have date (1/1/14,2/1/14,3/1/14...)

and the y axis i will have the number employees that are abroad...

how can i create that?

do i need anothe table or not?

adi

[its_anandrjs]

Use

DateField in the X-axis and in the Y that is expression use Count(employee)

But from which date you have to use in the X-axis otherwise use master calendar date but chart may warys.

[#3]

Hi,

Please find the attachement.

[#4]

what is the date you want to use in X-axis

[adiarnon]

the min date should be -min(from date) the max date max(to date)

[hic · Accepted solution]

You should create all dates in the intervals using a while loop. See

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

HIC

[adiarnon]

tnx,

but i cant open documents =/

can u explain me in words your solution?

[#8]

use autogenerate function to generate dates between min and max date. use this as your X-axis or use master calendar. U can see many post for master calendar in community.