Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

date

Hi Community,

i'm adding a new measure called 30 DAYS but unfortunately it doesn't work

Could you help me?

Immagine.png

4 Replies
fmazzarelli
Contributor III

Re: date

ops,

Month(date(today(),'DD/MM/YYYY'))

MVP
MVP

Re: date

maybe

=if([Data Documento] <= Today() and [Data Documento]>=AddMonths(Today(),-1), 30, 0)

fmazzarelli
Contributor III

Re: date

and

if ([Data Documento]<= today() and [Data Documento]>= AddMonths(today(),-1),30,0)

How is the statement correct?

fmazzarelli
Contributor III

Re: date

if ([Data Documento]< (DateAdd(day, -1, AddMonth(today(),-4))), 'OLTRE 120',0)

Community Browser