topic Re: current and last year data in QlikView

current and last year data

Tue, 24 Jun 2014 05:26:17 GMT

Hi all,

i have a graph that is showing data of current and last year at a same time.

but as im not sure about last year data so i just want this last graph will be valid from starting from this year ??

and it will not include the data of last year ??

Re: current and last year data

jagan — Tue, 24 Jun 2014 05:56:29 GMT

Hi,

Try like this

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

Note: Replace Month, Date, Year with your actual field names.

Regards,

Jagan.

Re: current and last year data

ashfaq_haseeb — Tue, 24 Jun 2014 05:59:23 GMT

Hi yougit try below

1. Current Year

=Sum({$<Month=, Date=, Year={$(=Only(Year))}>} Sales)

=sum({<Month=, Date=, Year={$(=max(Year))}>}Sales)

2. Previous Year

=Sum({$<Month=, Date=, Year={$(=Only(Year)-1)}>} Sales)

=sum({<Month=, Date=, Year={$(=max(Year)-1)}>}Sales)

Regards

ASHFAQ

Re: current and last year data

Tue, 24 Jun 2014 06:03:21 GMT

Hi ,

i'm already using this expression.

sum

({<FiscalYearName={'$(vLFY)' }>}Sale)*688.17/10000000000+sum({<FiscalYearName={'$(vLFY)' }>}(BONDED_SALE+DUTY_PAID_SALE)*688.17/10000000)

but wat i want my last year graph will show data from 2014-2015 onwards . not before that

Re: current and last year data

ashfaq_haseeb — Tue, 24 Jun 2014 06:06:11 GMT

Hi,

Can you post your sample application?

Regards

ASHFAQ

Re: current and last year data

Tue, 24 Jun 2014 06:45:48 GMT

please suggest smething ?

Re: current and last year data

selvakumarsr — Tue, 24 Jun 2014 06:49:53 GMT

Then you can limit the same using condition in Dimension itself..

Re: current and last year data

Tue, 24 Jun 2014 06:56:51 GMT

can u give some example ??

i'm using fiscal month as a dimension?/

Re: current and last year data

selvakumarsr — Tue, 24 Jun 2014 07:04:33 GMT

Are you displaying Rolling months like Last april to this march ?

Re: current and last year data

Tue, 24 Jun 2014 07:36:09 GMT

yes

Re: current and last year data

Tue, 24 Jun 2014 10:07:29 GMT

any suggestion???/