6 Replies Latest reply: Jul 17, 2014 5:10 PM by Udip Shrestha

# set analysis with year

Hi,

wanted set analysis expression for July 17  2013 to 16 July 2014

• ###### Re: set analysis with year

Hi anil

Try this workaround! You will end up have the possibility to select a from and a to date....

http://community.qlik.com/message/397578#397578

Kind regards,

Anthony

• ###### Re: set analysis with year

Hi,

Suppose you have two date

let v_Start_date = 07/17/2013

let v_End_date = 07/16/2014

then write expression like this

Sum({<DateField = {">=\$(=Date(v_Start_date)<=\$(=Date(v_End_date)"} >} Value)

Regards,

Vivek

• ###### Re: set analysis with year

Hi,

Try below,

• ###### Re: set analysis with year

Hi Anil,

Try the below expression which is dynamic and it works one day back every day and pick data from 12 months back to till date one day back as you give dates July 17  2013 to 16 July 2014.

• ###### Re: set analysis with year

first create two variable in Edit Script

Let vMinDate = 07/17/2013

Let vMaxDate = 07/16/2013

Then, in expression use this:

FUNCTION({<Date = {">\$(vMinDate)<=\$(vMaxDate)"}>} FIELD)

Hope this helps.