topic Re: Fiscal Year Comparison in QlikView

Fiscal Year Comparison

Fri, 22 Jun 2012 05:00:26 GMT

i have a field in my table with the name BE_Fiscal_Year and some amount associated with every Fiscal Year,

I want to sum all the amount for the current fiscal year ( i have calculated current fiscal year in a variable by the formula YearName(Today(),0,7) , and it has correct value in it),

I want to write a simple expression which sum the values of all the amounts for the value in the variable

sum({<BE_Fiscal_Year={"$(Current_Fiscal_Year)"}>} amount)

Thanks & Regards

Re: Fiscal Year Comparison

Fri, 22 Jun 2012 05:10:59 GMT

Hi,

Try This One

sum({<BE_Fiscal_Year=, BE_Fiscal_Year={"$(Current_Fiscal_Year)"}>} amount)

Re: Fiscal Year Comparison

Fri, 22 Jun 2012 05:14:29 GMT

Hi,

try this

=sum( { <[BE_Fiscal_Year]={$(Current_Fiscal_Year)} >} amount)

remember that BE-Fiscal_Year shoud be in number format not text.

regards

Apurva

Re: Fiscal Year Comparison

jagan — Fri, 22 Jun 2012 06:24:45 GMT

Hi,

Try this

=sum({<BE_Fiscal_Year={'$(=Current_Fiscal_Year)'}>} amount)

Check wheter BE_Fiscal_Year and Current_Fiscal_Year format are same.

Regards,

Jagan.

Re: Fiscal Year Comparison

Fri, 22 Jun 2012 06:40:15 GMT

thank you everyone, i got the solution

sum({<BE_Fiscal_Year={"=$(Current_Fiscal_Year)"}>} amount)