# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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)

Agnaldo Neves
7 Replies
MVP

## 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

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)

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:

NÃO,

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

>} VALOR_EMIS_NOVO_REC)

Agnaldo Neves
Esteemed Contributor II

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

ok, Please post some sample data

Valued Contributor

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

Example attachment

Agnaldo Neves
MVP

## 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'))"}

Valued Contributor

Did not work

Agnaldo Neves