topic Re: expression help in QlikView

expression help

Fri, 19 Apr 2013 10:01:39 GMT

Im trying to make an expression from a list of dates.

I want to count all items from last year, - so something like this

count (if(year(DATE)-1, ITEMS))

but this doent work???

manideep78 — Fri, 19 Apr 2013 10:04:40 GMT

Try this,

Count({<Year={">=$(=Year(DATE)-1)"}>}items)

Fri, 19 Apr 2013 10:08:27 GMT

Try tihis ,

Count ( {<Year(MyDateField)={'>=$(=Year(Today())-1)'} >} ITEMS)

//yusuf

jagan — Fri, 19 Apr 2013 11:02:57 GMT

Hi,

Try like this

=Count({<Date={">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}items)

Hope this helps you.

Regards,

Jagan.