how to use interval match()

[#1]

hi experts....

I have a bellow two tables

I want to create bar chart showing count of live properties at each date

Any help would be much appreciated!  

[Chanty4u]

chk dis

Interval Match Feature/Function

[HirisH_V7]

Hi,

Look into this,

help using a 'BETWEEN' join on tables from different datasources

IntervalMatch

-Hirish

[MK_QSL]

I don't think so you need intervalmatch for above two table which you have shown.. You can simply load them with/without join in qlikview and still able to associated them using ID field.

[HirisH_V7]

Hi,

If you want to see the difference between the Days means,

Load Your Tables,

Data:
LOAD * INLINE [
    Property ID, Properties
    1, A
    2, B
    3, C
    4, D
];

LOAD * INLINE [
    Property ID, LiveStart, LiveEnd
    1, 01/12/2015, 04/12/2015
    2, 01/12/2015, 05/12/2015
    3, 01/12/2015, 06/12/2015
    4, 02/12/2015, 23/12/2015
];

Then at front end ,

NetWorkDays(LiveStart,LiveEnd)

In this you can include holidays too like this,

NetWorkDays(LiveStart,LiveEnd,'03/12/2015')

Check this,

NetWorkDays

HTH,

PFA,

Hirish

[#6]

here is the coding for ur question try ith this@@@@

PropertyDetails:

LOAD

ID as [Property ID] ,

    Replace(purgechar(PROPERTIES,'0123456789'),' ','') as PROPERTIES

FROM

(biff, embedded labels, table is [Property$]);

join

LOAD [Property ID],

     date([Live Start]) as [Live Start],

     if(IsNull([Live End]),date(today()),[Live End]) as [Live End]

FROM

(biff, embedded labels, table is [Status$]);

join

data:

LOAD

[Property ID],

Date([Live Start] +IterNo()-1) as Date,

RowNo() as rownumber

Resident PropertyDetails

while([Live Start]+IterNo()-1<=[Live End]);

[#7]

Hi,

Please refer to this link :

Interval Match Feature/Function

Regards,

Snehal Nabar

[#8]

thank you for your reply Hirish V but I dnt understand how it will shows 15 for the last date there is totally 4 property only right?

[#9]

Thanks for all your reply guys ..I don't  need  to join that two tables I just want to count a total property for the each date by using intervalmatch function I tried like below

but it will shows error. so please suggest me how could I over come this error??

[Kushal_Chawda]

Data:

LOAD PropertyId,

            StartDate,

            EndDate,

           Date( StartDate + iterno()-1 ) as Date

From Table

While StartDate+iterno()-1<= EndDate;

Create the straight table

Dimension:

Date

Expression:

Count( distinct PropertyId)