topic Re: travel date data problem in QlikView

travel date data problem

adiarnon — Wed, 09 Jul 2014 06:11:33 GMT

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

Re: travel date data problem

its_anandrjs — Wed, 09 Jul 2014 06:17:29 GMT

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.

Re: travel date data problem

Wed, 09 Jul 2014 06:20:10 GMT

Hi,

Please find the attachement.

Re: travel date data problem

Wed, 09 Jul 2014 06:21:53 GMT

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

Re: travel date data problem

adiarnon — Wed, 09 Jul 2014 06:23:49 GMT

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

Re: travel date data problem

hic — Wed, 09 Jul 2014 06:24:30 GMT

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

Re: travel date data problem

adiarnon — Wed, 09 Jul 2014 06:24:48 GMT

tnx,

but i cant open documents =/

can u explain me in words your solution?

Re: travel date data problem

Wed, 09 Jul 2014 06:36:29 GMT

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.