topic Re: Coding help?? in QlikView

Coding help??

rohitians — Fri, 06 Dec 2013 09:02:58 GMT

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

Fri, 06 Dec 2013 09:29:22 GMT

Hi,

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

Fri, 06 Dec 2013 09:38:20 GMT

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 — Tue, 10 Dec 2013 05:24:21 GMT

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