# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## Result of any Date+X days in qlik sense

hi,

considering the date as filter and X as another filter.

If i click on date(07/22/2017) and X as 4, i need a result of july22 to july 26.

tried with expression

Sum({<[dimension_field]={'=[date]<= [date]+x'}>}metric)

but not getting proper result.

can anyone say the correct expression for this.

thanks

Tags (4)
1 Solution

Accepted Solutions
MVP

## Re: Result of any Date+X days in qlik sense

At the least you need to fix the quotation marks to be double quotation as you are trying to do a search which requires double quotation in the later versions of Qlik Sense. In addtion I believe that you want all dates between [date] and up to [date]+x and then you have to fix that too:

Sum( {<[dimensions_field]={">=\$(=[date])<=\$(=Date([date]+X))"}>} metric )

Or something more like this:

Sum({<[date]={">=\$(=[date])<=\$(=Date([date]+X))"},X=>} [Sales Qty] )

2 Replies
MVP

## Re: Result of any Date+X days in qlik sense

At the least you need to fix the quotation marks to be double quotation as you are trying to do a search which requires double quotation in the later versions of Qlik Sense. In addtion I believe that you want all dates between [date] and up to [date]+x and then you have to fix that too:

Sum( {<[dimensions_field]={">=\$(=[date])<=\$(=Date([date]+X))"}>} metric )

Or something more like this:

Sum({<[date]={">=\$(=[date])<=\$(=Date([date]+X))"},X=>} [Sales Qty] )

New Contributor II

## Re: Result of any Date+X days in qlik sense

Hi !!

Try this!

sum({<datefield={" >=\$(=max(datefield))<=\$(=num(max(datefield))+X) "}>}sales)

Hope this works fine!!