Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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

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

Regards,

Jagan.

ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you post your sample application?

Regards

ASHFAQ

Not applicable
Author

please suggest smething ?

selvakumarsr
Creator
Creator

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

Not applicable
Author

can u give some example ??

i'm using fiscal month as a dimension?/

selvakumarsr
Creator
Creator

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

Not applicable
Author

yes