Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rochdkhouloud
New Contributor

Date Condition

Hello dear community,

Can someone help me to create a condition about the date where date = Today -29days

11 Replies
MVP
MVP

Re: Date Condition

Where should this condition be applied?

- In an expression for a measure?

- For filtering out dates in a date dimension+

- Will it be used in the load script?

- Will it be used in your visualization?

ecolomer
Honored Contributor II

Re: Date Condition

You con write:

=date(today()-29,'DD/MM/YYYY')

P_fecha.png

rochdkhouloud
New Contributor

Re: Date Condition

It will be used in the load script

rochdkhouloud
New Contributor

Re: Date Condition

p1.PNG

rochdkhouloud
New Contributor

Re: Date Condition

p2.PNG

rochdkhouloud
New Contributor

Re: Date Condition

Thank you for your answer but I have this error above in the pictures

ecolomer
Honored Contributor II

Re: Date Condition

In the script ...

where Date > date(Today() - 29)

chinnuchinni
Contributor III

Re: Date Condition

you can check with your Date field  format, your Date  Field  should be same as your condition date format.


or else you can upload the sample app.


sasiparupudi1
Honored Contributor III

Re: Date Condition

Try

define a variable in script

Let vFilterDate=Date(today()-29,'DD/MM/YYYY');

in the where condition, use as below

Date>'$(vFilterDate)'

Community Browser