Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
danilodct
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:

image1.png

13 Replies

Re: Date Problem

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

Count(CLIENT)

danilodct
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.

manucamon
Valued Contributor III

Re: Date Problem

count(

{

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

}

CLIENT)

Re: Date Problem

count(

{

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

}

CLIENT)

danilodct
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

danilodct
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

manucamon
Valued Contributor III

Re: Date Problem

Can you share your app?

Thanks!

danilodct
New Contributor III

Re: Date Problem

thats my app!

Thanks to all for your support!

Re: Date Problem

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

Capture.PNG