Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rohitians
Creator III
Creator III

Coding help??

Hello,

I have the following code,

IF (not match(COMPANY,'XYZ'),

SUM({1<COMPANY={'XYZ'},FinancialYear=,Date={">=$(=max(YearStart))<=$(=max(YearEnd))"}>}Values/10000000),

SUM({$<COMPANY={'XYZ'},FinancialYear=,Date={">=$(=max(YearStart))<=$(=max(YearEnd))"}>}Values/10000000)

)


For getting the last years figures what changes are to be made...??


Thanks and Regards,

Rohit

1 Solution

Accepted Solutions
rohitians
Creator III
Creator III
Author

Hello everyone,

Thanx for the reply ..

I used the following codes.

CY:

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},COMPANY-={'XYZ'},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000

LY:

Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},COMPANY-={'XYZ'}

,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}

>}Values )/10000000

Thanks,

Rohit

View solution in original post

3 Replies
Not applicable

Hi,

If you have a year field, try max(year)-1

Not applicable

hi

try on this code, hope this helps you.

sum( {$<Year = {$(=Only(Year)-1)}>} Sales )

returns the sales for the previous year in relation to the current

selection. Here, a dollar-sign expansion is used to calculate

previous year.

********************************************************************************

sum(({<Year={$(=max(Year))},

Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)

Returns this year’s sales for customers who had sales last year.

rohitians
Creator III
Creator III
Author

Hello everyone,

Thanx for the reply ..

I used the following codes.

CY:

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},COMPANY-={'XYZ'},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}Date))"}>}Values )/10000000

LY:

Sum({$<FinancialYear=,FiscalYear={$(=max(FiscalYear)-1)},COMPANY-={'XYZ'}

,Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-1,4))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}Date),-12))"}

>}Values )/10000000

Thanks,

Rohit