Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

agnaldoneves
Valued Contributor

I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Returns me due date to date today: It's OK

Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}, Diar={'<=$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC) 


I need you to bring me to the current month.?

Example:

Month        Valor

Abr            125.000,00

Mar           854.000.00

Fev           822.000,00

Jan           322.000.00




Example set analysis: It's OK

Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}, Diar={'<=$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC) 

2017-04-21_21-49-48.png

Agnaldo Neves
Programador de Sistemas
7 Replies

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

From this data set.

Example:

Month        Valor

Abr            125.000,00

Mar           854.000.00

Fev           822.000,00

Jan           322.000.00


Are you expecting this?

Abr            125.000,00

vinieme12
Esteemed Contributor II

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

So you want the full month? then remove the day part of set analysis

Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}, Diar={'<=$(=Day(Today()))'} >} VALOR_EMIS_NOVO_REC)


and use just this


Sum({$<Anor ={$(=Year(today()))}, Mêsr={$(=Month(today()))}>} VALOR_EMIS_NOVO_REC)


or if you want only till March, then


Sum({$<Anor ={$(=Year(today()))}, Mêsr={"<$(=Month(today()))"}>} VALOR_EMIS_NOVO_REC)



agnaldoneves
Valued Contributor

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH


Preciso do corrente ano, até o mês atual, até o dia atual,.

That is the date until today


A data tem continuidade, mais do que o mês e hoje

Exemplo:

2017-04-22_09-16-25.png


NÃO,

Sum ({$ <Anor = {$ (= Ano (hoje ()))}, MESR = {$ (= mês (hoje ()))}

>} VALOR_EMIS_NOVO_REC)

2017-04-22_09-03-31.png



Agnaldo Neves
Programador de Sistemas
vinieme12
Esteemed Contributor II

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

ok, Please post some sample data

agnaldoneves
Valued Contributor

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Example attachment

Agnaldo Neves
Programador de Sistemas

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

May be use this in your expression

CalendarDater = {"<=$(=Date(Today(), 'DD-MMM-YYYY'))"}

agnaldoneves
Valued Contributor

Re: I NEED TO FILTER YEAR CURRENT UP TO THE CURRENT MONTH

Did not work

Agnaldo Neves
Programador de Sistemas
Community Browser