topic Re: Expression help? Compare last year and this year in QlikView

Expression help? Compare last year and this year

Thu, 26 Mar 2015 06:18:41 GMT

I need to count items sold this year(ytd) and count items sold i the same periode last year as this year.

ex. how many sold items from 1. jan 2014 to 26. march 2014 compared to same period this year

So please help med with an expression something like this

Maybe something with last maxDate or create a variable with something like

=date(Today()-365,'DD-MM-YYYY')

Count ({<AAR={$(vPreviousYear),$(vCurrentYear)}, sameperiod??>}items)

MK_QSL — Thu, 26 Mar 2015 08:07:35 GMT

For This Year

=SUM({<Year=,Month=,Week=,Date = {">=$(=YearStart(Today(),0))<=$(=AddYears(Today(),0))"}>}Sales)

For Last Year

=SUM({<Year=,Month=,Week=,Date = {">=$(=YearStart(Today(),-1))<=$(=AddYears(Today(),-1))"}>}Sales)

Instead of SUM(Sales), use Count(Items) in your case..

Thu, 26 Mar 2015 10:28:22 GMT

Hi Manish

Is it possible to make it into one expression

MK_QSL — Thu, 26 Mar 2015 10:48:14 GMT

='Current Year : ' & SUM({<Year=,Month=,Week=,Date = {">=$(=YearStart(Today(),0))<=$(=AddYears(Today(),0))"}>}Sales)

& CHR(10) &

'Last Year : '& SUM({<Year=,Month=,Week=,Date = {">=$(=YearStart(Today(),-1))<=$(=AddYears(Today(),-1))"}>}Sales)

Thu, 26 Mar 2015 11:57:15 GMT

Hi Manish

I have to use the expression to make a pie chart, and with your latest reply it doent work?????

MK_QSL — Thu, 26 Mar 2015 12:00:16 GMT

Provide sample data or your sample apps.

Thu, 26 Mar 2015 12:04:46 GMT

Sorry Not possible

MK_QSL — Thu, 26 Mar 2015 12:09:27 GMT

OK... Best Luck..!