To obtain different result with the same table

massimo6919 — Tue, 05 Feb 2013 15:47:53 GMT

Hi,

I have a table in which there is a string field that rapresent a count, an field description, an field data and a field amount.

From the field data i extract another 2 fields month(data) as mese and year(data) as anno and i want to obtain selecting month and year

the amount per definition of the selectioned year and for the precedent year.

The chart must be ...

Description	Jan-2013	Jan-2012	%
Accantonamenti	0	50	-100
Altri acquisti	123	123	0
Imposte e tasse	120	100	+20
Salari	50	0	+100
...

wherte in dimensions there is the description , and the 2 expressions are :

sum(TOTAL <description> if (year(data)= <selectioned year>,amount,0)

and

sum(TOTAL <description> if(year(data)-1=<selectioned year>,amount,0)

but is not correct and above all, i see only the values that are present in each expression

topic To obtain different result with the same table in QlikView