topic Please Help in QlikView

Please Help

Fri, 05 Sep 2014 09:46:03 GMT

Dear All

Please tell how to Make Logic with condition Mentioned Below

from today's [current] date to last six month.

how can i write logic for this

Thanks In Advance!

Timba

alexandros17 — Fri, 05 Sep 2014 09:50:14 GMT

I need more detail to help you,

you may use addmonths (Today(),-6) that return 2014/03/05

in this case you can set a condition where values are taken between the two dates

Fri, 05 Sep 2014 09:51:30 GMT

Hi ,

Try Like this .

Expression

=sum({<trn_Date={'>=$(VarPrev6Maxdate) <=$(VarMaxdate)'}>} amount)

Variables

VarPrev6Maxdate : date(max(trn_Date),'DD-MM-YYYY')

VarMaxdate : Date(AddMonths(VarMaxdate,-6),'DD-MM-YYYY')

Thanks !!

MayilVahanan — Fri, 05 Sep 2014 09:54:54 GMT

Try like this

=sum({<DateField ={">=$(=Date(MonthStart(Max(DateField),-5),'DD-MM-YYYY')) <=$(=date(max(DateField),'DD-MM-YYYY'))"}>} amount)