topic Re: set analysis with year in QlikView

set analysis with year

Thu, 17 Jul 2014 05:22:53 GMT

Hi,

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

Re: set analysis with year

Thu, 17 Jul 2014 05:24:27 GMT

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

Thu, 17 Jul 2014 05:47:22 GMT

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

Anonymous — Thu, 17 Jul 2014 05:56:06 GMT

Hi,

Try below,

Sum({<DateField = {">=$(=Date(AddMonths(Today()+1,-12))<=$(=Date(Today()-1)"} >} Value)

Re: set analysis with year

its_anandrjs — Thu, 17 Jul 2014 06:02:31 GMT

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.

=Sum({$<Date = {'>=$(=AddMonths(Date(Today()),-12)) <=$(=Date(Today()-1))'}>} Sales)

Re: set analysis with year

MK_QSL — Thu, 17 Jul 2014 20:39:17 GMT

=SUM({<Date = {">=$(=Date(AddMonths(Today(),-12))<=$(=Date(Today()-1)))"}>}Sale)

Re: set analysis with year

Thu, 17 Jul 2014 21:10:38 GMT

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.