Set Analisys take an element

[danosoft]

I want to do this set analisys taking a value from my list box,

when i choose "CESSAZIONE" and "RECESSO" in my list box

this set analisis work if i choose ONE of those two elements:

Sum({<DATA_OUT={"=Aggr(Max(DATA_OUT), MESEOUT, COD_PUNTO)"},STATO_OUT={"$(=GetFieldSelections(STATO_OUT))"} -  {'SCADENZA'}>} CONSUMO_TOT_ANNUO),

but if i choose ALL TWO elements ("cessazione" and "recesso") this not work, no rows return...... why?

thanks

[Anonymous]

I suppose that it's because getfieldselections separtes the tiems with a commy

like CESSAZIONE, RECESSO

but Set Analysis requires 'CESSAZIONE','RECESSO'

try

like =chr(39) & concat(distinct STATO_OUT, chr(39) &', ' & chr(39)) & chr(39) 

Sum({<DATA_OUT={"=Aggr(Max(DATA_OUT), MESEOUT, COD_PUNTO)"},STATO_OUT{$(=chr(39) & concat(distinct STATO_OUT, chr(39) &', ' & chr(39)) & chr(39) )} -  {'SCADENZA'}>} CONSUMO_TOT_ANNUO),

I hope that the Syntax is correct ( I tried it with my own set analysis and it worked)

[danosoft]

sorry but it not worked, no rows returned

[Anonymous]

can you send example qvw?

[danosoft]

in this way it not work in all case:

1. when i choose one value

2. when i choose the two values

3. when i not choose values (when i not choose values it need to show the same rows when i choose the two values)

[danosoft · Accepted solution]

hi, i find the errror in set analisys:

Sum({<DATA_OUT={"=Aggr(Max(DATA_OUT), MESEOUT, COD_PUNTO)"},STATO_OUT={$(=chr(39) & concat(distinct STATO_OUT, chr(39) &', ' & chr(39)) & chr(39) )} -  {'SCADENZA'}>} CONSUMO_TOT_ANNUO),

in this way it work

need after STATO_OUT an =

[Anonymous]

can you define Expression chr(39) & concat(distinct STATO_OUT, chr(39) &', ' & chr(39)) & chr(39) into as text object and see the Output. it should be like 'CESSAZIONE','RECESSO'

your third condition would not be fulfilled with this Expression. I would try with getselectedcount(STRATO_OUT) = 0 and do something different

[Anonymous]

great, didn't see that while pasting