only(Year)-1 doesn't work

[Anonymous]

Hi!

I'm struggling  with a problem that i think has something to do with the format of Year.

I'm loading a crosstable like this;

Data:

CrossTable(Year, Amount, 5)

LOAD [Company],

     Distributor

     Code,

     Family,

     Category,

     [2008],

     [2009],

     [2010]

FROM

(ooxml, embedded labels, header is 1 lines, table is DATA);

I've tried to change the format in the excel file for year but it doesn't change. I'va also tried to change it in the document settings as well but no luck.

Hence, this expression does not work;

=Only(Year)-1

Please Help

( =Only(Year) works fine though..)

[IAMDV]

Qlikview is interpreting the previous Field Names as string. And using the Only or Num function will not convert the Field type. However, if you use Num# - QV evaluates the expression numerically according to the string given as format-code.

So you if you use Num#(MyYear) -1  AS PreviousYear in the resident load, it should work. Do let me know if you need further help!

Cheers - DV