Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

What is wrong with this expression? Trying to get items in the past 30 days

I am trying to pull back a list of projects created in the past 30 days along with a couple of other conditions.  What is wrong with this expression?   Sum({$<CostGrp_IsActive = {'Yes'}, Trans_Type= {'D'},CostGrp_IsDetailed={'Detailed'},Created_Date >= {Date(Today()-30,'YYYY/MM/DD')}>}CostGrp_Contract_Amt)

1 Solution

Accepted Solutions
mkelemen
Not applicable

Re: What is wrong with this expression? Trying to get items in the past 30 days

Hi,

I think you need to use

Created_Date = {">=$(=Today() - 30)"}

BR,

  Matus

4 Replies
vinieme12
Not applicable

Re: What is wrong with this expression? Trying to get items in the past 30 days

Try below

Sum({$<CostGrp_IsActive = {'Yes'}, Trans_Type= {'D'},CostGrp_IsDetailed={'Detailed'},Created_Date = {">=$(=Date(Today()-30,'YYYY/MM/DD'))"}>}CostGrp_Contract_Amt)

mkelemen
Not applicable

Re: What is wrong with this expression? Trying to get items in the past 30 days

Hi,

I think you need to use

Created_Date = {">=$(=Today() - 30)"}

BR,

  Matus

Not applicable

Re: What is wrong with this expression? Trying to get items in the past 30 days

Thank you very much, however this resulted in no records coming back.

Not applicable

Re: What is wrong with this expression? Trying to get items in the past 30 days

Thank you, this worked perfectly.