topic Re: how to use interval match() in QlikView

how to use interval match()

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: how to use interval match()

Chanty4u — Thu, 12 May 2016 05:10:32 GMT

chk dis

Interval Match Feature/Function

Re: how to use interval match()

HirisH_V7 — Thu, 12 May 2016 06:22:05 GMT

Hi,

Look into this,

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

IntervalMatch

-Hirish

Re: how to use interval match()

MK_QSL — Thu, 12 May 2016 06:24:25 GMT

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.

Re: how to use interval match()

HirisH_V7 — Thu, 12 May 2016 06:35:40 GMT

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

Re: how to use interval match()

Thu, 12 May 2016 07:02:43 GMT

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]);

Re: how to use interval match()

Thu, 12 May 2016 11:21:18 GMT

Hi,

Please refer to this link :

Interval Match Feature/Function

Regards,

Snehal Nabar

Re: how to use interval match()

Thu, 12 May 2016 12:55:22 GMT

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?

Re: how to use interval match()

Thu, 12 May 2016 13:02:48 GMT

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??

Re: how to use interval match()

Kushal_Chawda — Thu, 12 May 2016 13:14:08 GMT

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)

Re: how to use interval match()

HirisH_V7 — Thu, 12 May 2016 13:41:10 GMT

Hi,

You can check that Network days function will exclude weekends i.e Saturday's and Sunday's and one more it is that inclusion '3/12/2015' .

HTH,

Hirish

Re: how to use interval match()

Anonymous — Thu, 12 May 2016 14:05:36 GMT

https://community.qlik.com/docs/DOC-3557

Re: how to use interval match()

Chanty4u — Fri, 13 May 2016 11:42:36 GMT

chk dis too

QlikView IntervalMatch

Re: how to use interval match()

Kushal_Chawda — Fri, 13 May 2016 11:48:06 GMT

[Live Data]:

LOAD [Property ID],

[Live Start],

[Live End],

Date( [Live Start]+ iterno()-1 ) as Date

From Table

While [Live Start]+iterno()-1<= [Live End];

PROPERTIES:

LOAD ID as [Property ID]

PROPERTIES

FROM Table;

Create the straight table

Dimension:

Date

Expression:

Count( distinct [Property ID])

Re: how to use interval match()

MindaugasBacius — Fri, 13 May 2016 11:53:39 GMT

According to your request: