Charting Issues

Tue, 08 Jul 2014 01:50:51 GMT

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.

Re: Charting Issues

Clever_Anjos — Tue, 08 Jul 2014 03:13:18 GMT

It would be easier if you post some data or qvw

Re: Charting Issues

VishalWaghole — Tue, 08 Jul 2014 04:13:55 GMT

Hi Arino, Please share some sample data and your logic, so we will get more clarity.

- Regards,

Vishal Waghole

topic Re: Charting Issues in QlikView

Charting Issues

Re: Charting Issues

Re: Charting Issues