topic Re: help with expression in QlikView

help with expression

arusanah — Wed, 01 Jul 2015 16:35:24 GMT

I Have two Charts A & Chart B

Two input Boxes FromDate & ToDate

Chart A : Dynamically Generated columns for current selection of FromDate & ToDate

=if( Date >= vFromDate and Date <= vToDate,Month(Date)&' - ' &right(Year(Date),2))

my requirement is to have

Chart B: which should Generate columns for previous year for same FromDate & ToDate selection

i tried this expression but doesnt work.

=if( Date >=date(num(MakeDate(year(vFromDate)-1,Month(vFromDate),Day(vFromDate)))) and Date <=date(num(MakeDate(year(vToDate)-1,Month(vToDate),Day(vToDate)))),Month(Date)&' - ' &right(year(vFromDate),2))

pls help!!

Re: help with expression

ramoncova06 — Wed, 01 Jul 2015 17:08:47 GMT

try with this

=if( Date >= addyears(vFromDate,-1),

and

Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY'))

Re: help with expression

arusanah — Wed, 01 Jul 2015 18:08:11 GMT

=if( Date >= addyears(vFromDate,-1) And Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY')))

DOESNT WORK

Re: help with expression

ramoncova06 — Wed, 01 Jul 2015 18:15:21 GMT

what is the date format of your variables ?

Re: help with expression

arusanah — Wed, 01 Jul 2015 20:52:01 GMT

sorry ramon,

It did work finally had some conflict with hidden dates . so cleared them