Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vivethakumar
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

1 Solution

Accepted Solutions
MVP
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
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] )

jothimala
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!!

Community Browser