topic Re: Current Year Vs Previous Year in QlikView

Current Year Vs Previous Year

abhaysingh — Sat, 07 Jun 2014 06:48:28 GMT

Hello Everyone

Pls help me in CY Vs PY logic.

want to show CY Vs PY Sales.

Re: Current Year Vs Previous Year

MK_QSL — Sat, 07 Jun 2014 07:04:13 GMT

Consider you have below script..

================

Sales:

Load * Inline

[

Customer, Sales, Year

A, 100, 2012

A, 120, 2013

B, 90, 2012

B, 110, 2013

C, 150, 2012

C, 110, 2013

];

===========================

You can show CY vs LY/PY sales growth as below

Create a Straight Table

Dimension

Customer

Expressions

2012 Sales

SUM({<Year = {2012}>}Sales)

2013 Sales

SUM({<Year = {2013}>}Sales)

Growth

SUM({<Year = {2013}>}Sales)/SUM({<Year = {2012}>}Sales)-1

Don't forget to change Number formatting of Growth to percentage from Properties = Number Tab

Re: Current Year Vs Previous Year

Sat, 07 Jun 2014 07:42:00 GMT

Instead of hardcoding 2012,2013.. values, create a variable vMaxYr = Max(Year()).

for PY you can use vMaxYr-1

Re: Current Year Vs Previous Year

its_anandrjs — Sat, 07 Jun 2014 07:58:42 GMT

You can create variable or by the use of the SET analysis you can create the expressions for Current Yr vs Previous Yr sales. But all ready explain by the member is right.

Current Year Sales

=Sum({<Year = {'$(=Max(Year))'}>} Sales)

By Formula use

=Sum({<Year = {"$(vCurrYr)"}>} Sales)

Previous Year Sales

=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)

By Formula Use

=Sum({<Year = {"$(vPrevYr)"}>} Sales)

Re: Current Year Vs Previous Year

Anonymous — Fri, 15 Dec 2017 05:56:36 GMT

if i am using above expression i am using same values for both current year and previous year

Re: Current Year Vs Previous Year

its_anandrjs — Fri, 15 Dec 2017 06:03:26 GMT

You have to by pass the other fields as well and did you create the correct variables because it is demo code.

Re: Current Year Vs Previous Year

Anonymous — Fri, 15 Dec 2017 06:08:07 GMT

i want to compare sales for current and previous year but i am getting same values for all. pease help

so for that i have declared

current year

curr_year = Max(sold_Year)

previous year

prev_year=max(sold_year)-1

for expression for current year

=num(sum({<sold_year = {"$(curr_year)"}>}[inv value])/(Sales_INR_Unit),'#,##0.0')

for expression for previous_year

=num(sum({< sold_Year = {"$(=$(prev_year))"}>}

[inv value]/Sales_INR_Unit),'#,##0.0')

for total growth

=num(

sum({<sold_year = {"$(curr_year)"}>}[inv value])

sum({< sold_Year = {"$(=$(prev_year))"}>}

[inv value])

sum({< sold_Year = {"$(=$(prev_year))"}>}

Re: Current Year Vs Previous Year

its_anandrjs — Fri, 15 Dec 2017 06:15:06 GMT

Did you check because i am getting different values

Please check the snap shot

Re: Current Year Vs Previous Year

Anonymous — Fri, 15 Dec 2017 06:24:52 GMT

Sir

please help

i have to replace year with my column name ie sold_year

so now expression will be

sum({sold_year={'$(max(sold_year))'}>} inv_value)

correct?

Re: Current Year Vs Previous Year

its_anandrjs — Fri, 15 Dec 2017 06:35:52 GMT

Check on this thread please for your answers.

Re: variable declaration of last year and current year?