working with multiple date feilds - Qlik Community

anuradhaa · ‎2014-03-26

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

MK_QSL · ‎2014-03-26

Can you provide some sample data?

anuradhaa · ‎2014-03-26

hi pls find attached sheet

its_anandrjs · ‎2014-03-26

Hi,

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

Thanks & Regards

Anonymous · ‎2014-03-26

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

anuradhaa · ‎2014-03-26

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