Set analysis with variable

[#1]

Hello everybody,

I have a silly problem about Set Analysis that I wasn't able to solve reading all the manuals and examples I found on internet.

I need to compare a field to a variable inside the modifier.

I have Pax associated to some IDs. I want the Sum of Pax for only a specific ID, contained in the variable vID1 (it is the latest ID obtained with the function rank, but I tested and it works)

Sum ({$<ID={"$(vID1)"}>} Pax)

Probably I am doing a mistake in the sintax, but I can't understand where!

Thanks!

Matt

[ashfaq_haseeb]

Hi,

Try like this

Sum ({$<ID={"$(=vID1)"}>} Pax)

or

Sum ({$<ID={'$(=vID1)'}>} Pax)

Regards

ASHFAQ

[#3]

Hi,

May be Try like below:

Sum ({$<ID={">=$(vID1)<=$(vID1)"}>} Pax)

Best,

Robert

[#4]

All 3 formulas gave me 0 as result.

If i write the formula without the Variable but with the # of the ID i get the sum of pax.

If i test the variable with (vID)  i get the right id.

If I put them together it doesn't work.

Thanks

Matt

[ashfaq_haseeb]

Hi,

Sample application attached for you.

Set analysis is case sensitive make sure you have same field name.

If possible post your application to help you with.

Regards

ASHFAQ

[simondachstr]

Try Sum ({$<ID={'$(=$(vID1))'}>} Pax)

[maxgro]

to debug set analysis

add a chart with only your expression, remove label as in image

and let we know the output

[#8]

Hi Mohammed,

I added a variable that rank the ID (like in my original case). Doing that your set analysis doesn't work anymore.

And it's the exact same case that I am facing, and I am not able to see what I am missing.

Thanks

Matt

[ashfaq_haseeb]

Hi,

Without seeing code its hard to analyze.

did you follow Massimo Grossi suggestion.

If possible post sample Application to look over.

Regards

ASHFAQ

[#10]

I added the chart as you told to the example I sent back to Mohammed, that's the output:

I don't get any error in the expression, but the sum it's just 0