Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

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

Count(CLIENT)

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

count(

{

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

}

CLIENT)

Kushal_Chawda

count(

{

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

}

CLIENT)

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Can you share your app?

Thanks!

Anonymous
Not applicable
Author

thats my app!

Thanks to all for your support!

sunny_talwar

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

Capture.PNG