Hi Qlikview Community,
Can anyone help me out? I'm working on a chart for a long-term parking Carpark. I have attached a sample of my overall chart as well as the chart after selecting a particular carpark. The X-axis shows the different carpark numbers while the y-axis shows the duration of how long each car is parked in YYYYMMDD.
As you can see from the overall chart, Carpark A2 only show 2 car parked (SFX100 and SX1024) but when I click on the Carpark A2 itself to look at specifics, suddenly 2 more cars appear (MH1005 and RT1020). May I know why is it so?
This is the formula I have used to calculate the duration of their stay.
RangeMax(above(Max (Car_Leaving_Date),0,rowno()))
-
RangeMax(Min (Car_Parking_Date),RangeMax(above(Max (Car_Leaving_Date),1,rowno()-1)))
The Dataset is something like this:
Car No. CarPark No. Car_Parking_Date Car_Leaving_Date Sequence
SX1001 A1 20140622 20140623 1
SX1009 A1 20140623 20140625 2
SX1010 A1 20140625 20140629 3
SX1002 A2 20140623 20140624 1
SX1003 A3 20140624 20140628 1
SX1004 A4 20140628 20140705 1
Any help would be appreciated. Thanks a lot. I have been stuck for a long time.
