date ranges selection and output mismatch.

[qliklearnervir]

Hi,

I am doing one requirement where i want to show "arrivaldate" and "Booking date" as a selection in calendar as from - To scenerio and final count of booking come as booking count.

as per my scenerio i want in certain date range of arrival date , how many booking happened with booking date ,  and similarly in date range of booking date , how many arrival count happen and vice versa.

but issue is like with actual data and date other reference date is   coming with 0 value count , which i don't want.

Like sql my final chart should show only matching value .

additionally i want year, month and day filter also for arrival as well as booking .

attached qvw and data for reference.

[MK_QSL]

For provided example, what output you are looking for?

[sunny_talwar]

To me, what you have in there is doing exactly what it should. Would you be able to explain your requirement once again? What is the expected output?

Arrivals are between 01-01-2015 and 02-02-2015 (b1 and b2) and Bookings are shown between 01-01--2014 and 30-06-2014(b1 to b7)

[qliklearnervir]

i dont want date to be populated if count is o.....like arrival from march to april     and booking from  jan to feb ,,,,i only want the date having both data else blank.

or want to replicate  scenerio like  arrival date  OR  booking date

                                                   arrival date AND booking date   than data should filter out......

[sunny_talwar]

Like this?

Try these two expressions:

Arrival

=If(Count({<arrivaldate={"$(='>=' & Date(vMinArrival) & '<=' & Date(vMaxArrival))"}>}booking) <> 0,

  Count({<arrivaldate={"$(='>=' & Date(vMinArrival) & '<=' & Date(vMaxArrival))"}>}booking))

Booking

=If(Count({<bookingdate={"$(='>=' & Date(vMinBooking) & '<=' & Date(vMaxBooking))"}>}booking) <> 0,

  Count({<bookingdate={"$(='>=' & Date(vMinBooking) & '<=' & Date(vMaxBooking))"}>}booking))

[qliklearnervir]

i am creating a new thread with updated data ...........