Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
marco_puccetti
Partner - Creator
Partner - Creator

Set Analisys Filtering

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

14 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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
Employee
Employee

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

Not applicable

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

marco_puccetti
Partner - Creator
Partner - Creator
Author

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

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

What's wrong here?

Thanks

Marco

Not applicable

You are ok.

this will give positive values ​​

jonathandienst
Partner - Champion III
Partner - Champion III

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]))


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
marco_puccetti
Partner - Creator
Partner - Creator
Author

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

Is it possible?

Immagine18.png

Not applicable

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

Not applicable

Use the conditional option , located above the expression.

With sum(Importo Assicu...)>0