Doubt to handle specific date filter (Qlik View)

0

Galera,

So, I have a little problem to write an expression, I've lost a few hours and I can not evolve.

The situation is as follows: I have 2 filters, one of Month and one of Year. It turns out that I need to bring the value based on a test of dates, and IF today's date is greater than the date of the last month of the filtered year I want the calculation is done based on the date of the last month and year filtered, otherwise I want it to be done based on the current month and year (today).

Soon % test is working correctly, because True and False appear in the situations I need.

So, if I filter 2017 the count will be based on 12/2017 regardless of the selected month. If I filter 2018 it should rely on 06/2018 because it is the month we are today, regardless of the month it is filtered.

The problem occurs when I include the count expression, it gives an error and I can not solve it.

if(today() > YearEnd(CALENDARIO.MESANO,0),'VERDADEIRO','FALSO')

My problem is occurring when I try to pass the date on CALENDAR.MESANO . Anyone have any ideas?

    
asked by anonymous 29.06.2018 / 11:53

0 answers