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!  

[HirisH_V7]

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

[Anonymous]

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

[Chanty4u]

chk dis too

QlikView IntervalMatch

[Kushal_Chawda]

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

[MindaugasBacius]

According to your request: