Coding Help Required...

rohitians — Mon, 06 May 2013 12:45:15 GMT

Hello,

I have the following code where in if i choose any year i get proper values but if i select a year and a month i do not get proper values ,

Please help..

Thanks and Regards,

Rohit

(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Gross Sales Amount])

-SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Sales Return Amount])

fabs(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

,[Is SRN]={0},

[GL Code]={"4000001","4000002","4000003","4000004","4000005","4000006","4000007","4000008","4000010","5000015","5000013","5000014","5000016"},FiscalYear={$(=max(FiscalYear))}>} [Credit Note Amount]))

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"},

[GL Code]={"4000001","4000002","4000003","4000004","4000005","4000006","4000007","4000008","4000010","5000015","5000013","5000014","5000016"},FiscalYear={$(=max(FiscalYear))}>} [Debit Note Amount]))

/100000

Re: Coding Help Required...

er_mohit — Mon, 06 May 2013 12:48:36 GMT

Try to add Month= in all like this

(SUM({$<FinancialYear=,Month=,FiscalYear={$(=max(FiscalYear))},MonthName=,Quarter=

,[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}

>}[Gross Sales Amount])

hope it helps

Re: Coding Help Required...

Gysbert_Wassenaar — Mon, 06 May 2013 12:50:43 GMT

If MonthName is the field you select your month in then remove MonthName=, from the expression since that's making the expression ignore your selection.

topic Re: Coding Help Required... in QlikView

Coding Help Required...

Re: Coding Help Required...

Re: Coding Help Required...