Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

francomonti
New Contributor

set analysis qlik sense

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

2 Replies

Re: set analysis qlik sense

Looking like these are the field and you defined as Variable, May be this?

Sum({<AnnoMese_Rata={"=AnnoMese_Rata > (Anno_Scadenza+Mese_Rata)"}>}Premio)

MVP
MVP

Re: set analysis qlik sense

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