Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Parking lot, peak pr. day

Dear sirs

I administer a parking lot, and I wish to measure the max/min usage pr. day/hour etc.

For now I have constructed a table that counts how many cars have parked in a certain time interval (15 mins)

the formula for this is sum(count) and Period is the dimension

Udklip.JPG

So - I can measure the no of cars parked on any given time.

Now i wish to create a chart that shows (with the date as the X-axis)

- average no of parked cars in every 15 min interval throuhout the day

- max of parked cars during the day (pr. 15 min interval)

- min of parked cars during the day

I have some trouble contruction the formulas for this. Can anyone throw a lifeline?

Thanks in advance.

Jesper

5 Replies
Not applicable

Re: Parking lot, peak pr. day

- average no of parked cars in every 15 min interval throuhout the day

- max of parked cars during the day (pr. 15 min interval)

- min of parked cars during the day

For this have dimension as period.

Expression;

1. Sum(Count)/ Sum(total Count)

2. Max(Count)

3. Min(Count)

You need to create a separate chart for each expression.

Not applicable

Re: Parking lot, peak pr. day

Thanks, I was hoping to have all expressions in the same chart.

One solution could be to calculate the max/min values in the script, I would prefer to have en expression based calcualtion though.

Jesper

Not applicable

Re: Parking lot, peak pr. day

No need to calculate Min/max values in the script. if we do this then reload time of script to be high.

Re: Parking lot, peak pr. day

can you please share some sample data

Not applicable

Re: Parking lot, peak pr. day

sure

Community Browser