Set Analisys Filtering

[marco_puccetti]

Hello, i need to know how to do the following thing using set analisys:

I need to get only the list of a field "A" that have related an other field "B" with the value >0, is it possible?

Thanks

Marco

[nagarjuna_kotha]

Yes ,we can do that,

Foe Example you have 10 years data in your dashboard, you want only one Year Sales data only.

Sum({<Field={'A'},Year={'2015'}>}Sales)

Are you looking like this ?

Regards,

Nagarjuna

[mjm]

Hello Marco,

I believe you will need a combination of set analysis and to also use getpossiblevalue to achieve what you need. Your case would be quite complicated, but an example to help can be found here:

Set Analysis - Get List of current selections into specific field

Sum( {<[SalesTargets.STMonth] = {$(=GetFieldSelections(IvMonthNo, ',',12))} >} SalesTargets.Quant)

You will need to of course replace the sum function to use the fields you have and use GetPossibleValue instead, but I believe this will help you.

Please mark this as helpful and correct if this answers your question

[#4]

sum({<fieldA={'A'},value={>0}>}value)

[marco_puccetti]

I have written this expression but it returns me a syntax error:

=Sum({<[FIELD A]={">0"}>}[FIELD A])

What's wrong here?

Thanks

Marco

[#6]

You are ok.

this will give positive values ​​

[jonathandienst]

The expression looks OK, so I am not sure about the error you are seeing - is the field name spelled correctly (including the case)?

This particular calculation can be done more simply:

=Sum(RangeMax(0, [FIELD A]))

[marco_puccetti]

I need to avoid the rows with the latest Column at zero.

Is it possible?

[#9]

The expressions called Premio and Numero di Pezzi do not allow it

[#10]

Use the conditional option , located above the expression.

With sum(Importo Assicu...)>0