Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

current and last year data

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 ??

10 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: current and last year data

Hi,

Try like this

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

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

Regards,

Jagan.

Highlighted

Re: current and last year data

Hi yougit try below

1. Current Year

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

or

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

2. Previous Year

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

or

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

Regards

ASHFAQ

Highlighted
Not applicable

Re: current and last year data

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

Highlighted

Re: current and last year data

Hi,

Can you post your sample application?

Regards

ASHFAQ

Highlighted
Not applicable

Re: current and last year data

please suggest smething ?

Highlighted
Creator
Creator

Re: current and last year data

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

Highlighted
Not applicable

Re: current and last year data

can u give some example ??

i'm using fiscal month as a dimension?/

Highlighted
Creator
Creator

Re: current and last year data

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

Highlighted
Not applicable

Re: current and last year data

yes