# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
New Contributor III

## Date Problem

Hi guys, my problem is:

• I have two tables: CLIENT and CALENDAR
• They are joined by YEAR_MONTH
• CLIENTE has a column called: INCLUSION_DATE
• In CALENDAR i have YEAR_MONTH, YEAR, MONTH, DAY, DATE

I would like to select YEAR=2016, MONTH=MAR and create a line chart that give me how many CLIENTs i have day by day of the whole selected month, from the day 1 to the 30.

My set analisys was:

count(

{

<INCLUSION_DATE={'<=\$(=DATE)'}>

}

CLIENT)

It works when i select just one DATE. But when i select the month the chart show me nothing.

My expectation is someting like this:

Tags (4)
13 Replies
MVP

## Re: Date Problem

If you have already selected Year and Month, I don't think you would need Set analysis:

Count(CLIENT)

New Contributor III

## Re: Date Problem

No... CLIENT and CALENDAR are joined by YEAR_MONTH.

With month selected and count(CLIENT) my chart will show:

• DAY from CALENDAR as Dimension: the same count value all days from the month
• DAY extracted from INCLUSION_DATE as Dimension: how many CLIENT was added in each day.

And what i want is: how many CLIENT i have until each day.

Valued Contributor III

## Re: Date Problem

count(

{

<INCLUSION_DATE={'<=\$(=Max(DATE))'}>

}

CLIENT)

MVP

## Re: Date Problem

count(

{

<INCLUSION_DATE={"<=\$(=max(DATE))"}, Month=>

}

CLIENT)

New Contributor III

## Re: Date Problem

Putting "Month=" the chart shows all dates from selected year.

Putting max(DATE) the chart shows, for all dates, the same value, the value of the max date: 31/12/2016

New Contributor III

## Re: Date Problem

Putting max(DATE) the chart shows, for all dates, the same value, the value of the max date: 31/03/2016

Valued Contributor III

## Re: Date Problem

Thanks!

New Contributor III

## Re: Date Problem

thats my app!

Thanks to all for your support!

MVP

## Re: Date Problem

Can you check your sample. The YEAR_MONTH and INCLUSION_DATE are not aligning up properly here