topic Re: working with multiple date feilds in QlikView

working with multiple date feilds

anuradhaa — Wed, 26 Mar 2014 11:58:56 GMT

Hi,

I have twp date fields arrival date and departure date for trucks.

here i want to display "Number of Trucks arrive" and "Number of trucks departure" on specific date.

user can select date in top date selection box.

say when user select jan 1st 2014, i want to display above data.

also i want to display the correct counts when user select multiple dates, say jan1st,2nd and 3rd.

So please tell me how to do this and how to design the date select box. This is a big problem to me and please help me.

Thanks

Re: working with multiple date feilds

MK_QSL — Wed, 26 Mar 2014 12:06:13 GMT

Can you provide some sample data?

Re: Re: working with multiple date feilds

anuradhaa — Wed, 26 Mar 2014 12:08:40 GMT

hi pls find attached sheet

Re: working with multiple date feilds

its_anandrjs — Wed, 26 Mar 2014 12:37:15 GMT

Hi,

From which field you are count "Number of Trucks arrive" and "Number of trucks departure"

Thanks & Regards

Re: working with multiple date feilds

Anonymous — Wed, 26 Mar 2014 12:40:03 GMT

See this from Henric Cronström:
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date

Re: Re: working with multiple date feilds

anuradhaa — Wed, 26 Mar 2014 12:43:04 GMT

from selected date,

i mean if he select date as jan 1st . i want that stat for jan 1st.

The problem i have is how can i have common date for both arrival and dep date. if i set the date list box using arrival. the it show only the records relevant to arrival date.

thanks