Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

munna1317
Contributor II

Problem With Date Function

Hi Everyone,

I have a date field . I want an expression for date greater than 30 days.

Date format(dd/mm/yyyy)

Date>30 days.

how it can be done , plz help me and sort out me with this problem,

Thxs in Advance ,

harish

1 Solution

Accepted Solutions

Re: Problem With Date Function

SUM({<Date = {'>$(=Date(Max(Date)-30))'}>}Sales)

or

SUM({<Date = {'>$(=Date(Today()-30))'}>}Sales)

2 Replies

Re: Problem With Date Function

SUM({<Date = {'>$(=Date(Max(Date)-30))'}>}Sales)

or

SUM({<Date = {'>$(=Date(Today()-30))'}>}Sales)

munna1317
Contributor II

Re: Problem With Date Function

thxs manish

Community Browser