Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculating Days in a chart

Hi,

I have data as follows

DateTotal MinutesMin_BookedMin_Avial
2/10/2014907515
2/11/2014907515
2/12/2014906030

Assuming today is 2/10/2014.

Today there is 15 minutes avialable

Today thru 2/11 there are 30 minutes available.

Today thru 2/12 there are 60 Minutes avialable.

In a chart I would like to report how may days until a total of 45 minutes are avaialbe. In this scenario above, it would be 2 days from today.

The chart would actually want to report the average number of days, by a variety of dimensions, until a total of 45 minutes is available.

I hope this makes sense. Any help would be great. I assume aggr would need to be used multiple times.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Calculating Days in a chart

Hey Tim,

Check out the attached file.

This is an just an idea on how to approach the issue. You can tweak it to your needs.

Thanks

AJ

3 Replies

Re: Calculating Days in a chart

How do the dimensions (and selections in those dimensions) influence the available minutes? Do you always calculate from the same fixed date (a date that could be used in the script) or should does a user select a date?


talk is cheap, supply exceeds demand
Not applicable

Re: Calculating Days in a chart

Hey Tim,

Check out the attached file.

This is an just an idea on how to approach the issue. You can tweak it to your needs.

Thanks

AJ

Not applicable

Re: Calculating Days in a chart

Thank you! This should work!

Community Browser