Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
why not select correcty this
Sum({<AnnoMese_Rata={'>$(Anno_Scadenza+$(vMese_Rata))'}>}Premio)
$(vMese_Rata) is variable
Movimenti_0:
LOAD * INLINE [
id,Frazionamento,Mese_Rata,Mese_Scadenza,AnnoMese_Rata, Nro_Polizza,Seq,Premio,data_scadenza
3,Q,5,5,201005,100,1,1350,10/05/2010
2,Q,9,5,201009,100,2,1350,10/05/2010
1,Q,1,5,201101,100,3,1350,10/05/2010
5,Q,10,10,201310,155,1,2350,21/10/2013
6,Q,2,10,201402,155,2,2350,21/10/2013
4,Q,6,10,201406,155,3,2350,21/10/2013
9,Q,9,9,201609,200,1,450,02/09/2016
8,Q,1,9,201701,200,2,450,02/09/2016
7,Q,5,9,201705,200,3,450,02/09/2016
12,Q,2,2,201602,150,1,900,28/02/2016
10,Q,6,2,201606,150,2,900,28/02/2016
11,Q,10,2,201610,150,3,900,28/02/2016
14,Q,1,1,201501,250,1,1500,15/01/2015
13,Q,5,1,201505,250,2,1500,15/01/2015
15,Q,9,1,201509,250,3,1500,15/01/2015
16,Q,6,6,200206,350,1,4350,21/06/2002
17,Q,10,6,200210,350,2,4350,21/06/2002
18,Q,2,6,200302,350,3,4350,21/06/2002
];
Movimenti:
NoConcatenate
load
id,
Frazionamento,
num(AnnoMese_Rata) as AnnoMese_Rata,
num(Mese_Rata) as Mese_Rata,
num(Mese_Scadenza) as Mese_Scadenza,
Nro_Polizza,
Seq,
Premio,
data_scadenza,
num(year(data_scadenza),'0000')*100 as Anno_Scadenza
Resident Movimenti_0;
drop Table Movimenti_0;
Thanks
Franco
Looking like these are the field and you defined as Variable, May be this?
Sum({<AnnoMese_Rata={"=AnnoMese_Rata > (Anno_Scadenza+Mese_Rata)"}>}Premio)
You should use double quotes when you do a search. It is important to use a field that is a unique id for the row in the table for the left hand side of the set analysis.
So I think this should work for you:
Sum( {<id={"=AnnoMese_Rata>(Anno_Scadenza+Mese_Rata)"}>} Premio)set analysis qlik sense