Set Expression with Date Island

[chrisjad]

Hi All,

 I have multiple tables with a created Date/Calendar island. 

In my Date Island script, I have added : 

Load

*,
If( DayNumberOfYear(Date) <= DayNumberOfYear(Today()), 1, 0 ) as IsInYTD
;

On the front-end of the app, I am trying to create a master item to have the YTD sales:

The formula I have without the year condition is the following: sum({$<IsInYTD = {1}>}[Invoiced in GC])

Now, I don' t  know how to include the date condition which would be [Clearing date]=Date .

I have tried this way it but does not work: sum({$<[Clearing date]=Date , IsInYTD = {1}>}[Invoiced in GC])

I have also tried with this formula: if([Clearing date]=Date,sum({$<IsInYTD = {1}>}[Invoiced in GC])) but then my bar chart gives me an error message "the line chart is not dislpayed because if containes only undefined values".

Any idea how to solve this? 

In my line chart, I am using the year and month field of my Calendar Island.

[chrisjad]

I will try this solution, but just for me to understand as I am new to Qlik, are you trying to link the payment table to the Date island table?  if so, why?  is it not supposed to be a stand alone table? 

Thanks again for your help 

[chrisjad]

It works for this graph but then all my other graphs I created so far based on the different date field conditions wont be displayed. 

[Tina18]

Hi!!

Did you find the solution to the date problem? Because I have the same doubt and I can't find a solution in any forum.

I appreciate any help you can give me.

[HeshamKhja1]

Any ideas here or is this not possible in Qlik frontend?