Count day in dynamic interval

Mon, 23 Dec 2013 07:26:40 GMT

I have this data in model:

Date DateEnd Flag

01/06/2013 01/09/2013 0

02/09/2013 23/12/2013 1

Date mean DateBegin interval for value of flag.

Now I want calc how many days in selected period (year, month, days, week - anything) in calendar Flag was 1.

Example:

If user selected November: Day for flag is 30.

If selected September: day for flag is 29.

If selected Jule: day for flag is 0.

If selected 01/06/2013 - 23/12/2013: day for flag is 113.

It is possible to calculate in expression?

Re: Count day in dynamic interval

swuehl — Mon, 23 Dec 2013 08:56:19 GMT

So you somewhere have a continuous Date field or calendar the user makes his selection in, right?

You can use INTERVALMATCH LOAD prefix in your script to link your flag periods to this date field (finally, I would probably join the flag to your calenda).

Then, doing your calculation is just summing the Flag value while user selects a Date field period.

topic Re: Count day in dynamic interval in QlikView

Count day in dynamic interval

Re: Count day in dynamic interval