topic syntax set analysis in QlikView

syntax set analysis

Wed, 28 Aug 2013 08:46:02 GMT

Hi i have a calculation whereby i calculate accumulated value. This works well for current year 2013/2014

=Sum(

{$<

FYear={"$(=Dual(Max(fYear)-1 &'/'& Max(fYear), Max(fYear)))"},

fMonth={"<=$(==Max( {<fYear={$(=Max(fYear))}>} fMonth))"}

Nettobelopp)

i have tried to show previous year without any luck 2012/2013. i think my syntax is wrong, any ideas?

=Sum(

{$<

FYear={"$(=Dual(Max(fYear)-2 &'/'& Max(fYear) -1, Max(fYear)-1))"},

fMonth={"<=$(==Max( {<fYear={$(=Max(fYear)-1)}>} fMonth))"}

Nettobelopp)

Best

Brad

MayilVahanan — Wed, 28 Aug 2013 08:50:25 GMT

can you explain FYear contains data format?

can you provide any sample data / sample file?

Wed, 28 Aug 2013 08:58:05 GMT

Thank you for your reply

i have attached the file.

the format of the FYear = 2013/2014;

MayilVahanan — Wed, 28 Aug 2013 09:54:10 GMT

Try like this

=Sum(

FYear={"$(=Dual(Max(fYear)-2 &'/'& (Max(fYear)-1), Max(fYear)-2))"},

fMonth={"<=$(=Max( {<fYear={$(=Max(fYear))}>} fMonth))"}

Nettobelopp)

Try like this

=Sum(

{$<

fYear={$(=Max(fYear)-1)},

fMonth={"<=$(=Max({<fYear={$(=Max(fYear))}>} fMonth))"},

FYear=

// månad,dag,datum

Nettobelopp)