topic Current Years Current Month Vs Last Year Same Month Data in QlikView

Current Years Current Month Vs Last Year Same Month Data

Anonymous — Tue, 17 Apr 2012 04:58:51 GMT

Hi All,

Need to display data in Guage chart

Current Years Current Month Vs Last Year Same Month Data.

Example

2012 Jan Data Vs 2011 Jan Data .

How to acheive this pls suggest me an idea.

Thks in advance

Re: Current Years Current Month Vs Last Year Same Month Data

Tue, 17 Apr 2012 05:16:11 GMT

Current Year and Current Month Exp:

sum({$<Year={$(=Max(Year))},Month={ "<=$(max({<Year={$(=Max(Year))}>} Month))>$(Max({<Year={$(=Max(Year))}>}Month)-1)"}>}

Last Year and Current Month Exp:

sum({$<Year={$(=Max(Year-1))},Month={"<=$(Max({<Year={$(=Max(Year))}>}Month))>$(Max({<Year={$(Max(Year))}>}Month)-1)"}>}

Regards,

Venkat Reddy

Re: Current Years Current Month Vs Last Year Same Month Data

Tue, 17 Apr 2012 05:36:53 GMT

hi,

just use this expression and take month as dimension:

For Current year: =Sum({$<Year={$(=Max(Year))}>}Sales)

For last Year:-= =Sum({$<Year={$(=Max(Year)-1)}>}Sales)

Refer to the atttached file:

Regards :

Arun Goel

Re: Current Years Current Month Vs Last Year Same Month Data

Tue, 17 Apr 2012 05:58:13 GMT

hi,

Last one is for bar chart,

for gauge chart use:

For current year-month=Sum({$<Year={$(=Max(Year))}, Mon={$(=Month(Today()))}>}Sales)

For last Year's same month=Sum({$<Year={$(=Max(Year)-1)}, Mon={$(=Month(Today()))}>}Sales)

Refer to attached file:

Enjoy!!!!!

Regards

Arun Goel

Re: Current Years Current Month Vs Last Year Same Month Data

Anonymous — Tue, 17 Apr 2012 06:56:09 GMT

hi Venkat,

Thanks for the suggestion

Current years Current month script works fine

Sum({$<Year={$(=Max(Year))}, Mon={$(=Month(Today()))}>}Sales)

but last year same month not working.

Sum({$<Year={$(=Max(Year-1))}, Mon={$(=Month(Today()))}>}Sales)... its returing consolidated of all the values for last year.

I need last years same month data ...

Example : 2012 Jan Data Vs 2011 Jan data

Thanks for the reply....

Re: Current Years Current Month Vs Last Year Same Month Data

Tue, 17 Apr 2012 07:36:05 GMT

try moving the closing bracket that's after Year-1 two positions to the left:

Sum({$<Year={$(=Max(Year)-1)}, Mon={$(=Month(Today()))}>}Sales)

You want the max(year) minus one, which is the previous year

Re: Current Years Current Month Vs Last Year Same Month Data

Anonymous — Tue, 17 Apr 2012 07:46:45 GMT

Hope the attached file will be helpful for you

Regards

Ashok

Re: Current Years Current Month Vs Last Year Same Month Data

Anonymous — Tue, 17 Apr 2012 08:17:17 GMT

Hi All,

Thanks for the reply...

I think i cannnot use today function , bcoz the latest data in our file is 2012 jan data..

so i need to compare 2012 Jan data and 2011 Jan data...

@Ashok , ur attached file gives an idea but i cannot use today function

Current Years Current Month Vs Last Year Same Month Data

SunilChauhan — Tue, 17 Apr 2012 08:19:37 GMT

for current year

=Sum({$<Year={$(=Max(Year))},Month={$(=max(fis_period_id))}>} [total_sales])

for Previous Year

=Sum({$<Year={$(=Max(Year)-1)},Month={$(=max(fis_period_id))}>} [total_sales])

hope this helps

Current Years Current Month Vs Last Year Same Month Data

Anonymous — Tue, 17 Apr 2012 08:22:51 GMT

Then you can create a variable and set the date (jan 2012) like

variable name = makedate(max(Year(Yourdatefield)),Max(Month(Yourdatefield)))

Then apply this variable instead of the today() in that attached expression.

Regards

Ashok

Re: Current Years Current Month Vs Last Year Same Month Data

Anonymous — Thu, 07 Sep 2017 21:01:25 GMT

Hi Arun,

What if we want to show the data for the year before the last year? What expression should we write?