Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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
jonathandienst
Partner - Champion III
Partner - Champion III

The row is suppressed when all expressions return null or zero. Change the other expressions to something like:

     =If([Importo Assicurato Unit] <> 0, .... existing expression.... )

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

t1.png

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

I've solved it using the "{<[Importo Assicurato Fondo]={">0"}>}" condition on all the fields of the column.

Thanks

Marco

nagaiank
Specialist III
Specialist III

Did you try this?

If(B > 0,A)

marco_puccetti
Partner - Creator
Partner - Creator
Author

I've solved it using the "{<[Importo Assicurato Fondo]={">0"}>}" condition on all the fields of the column.

Thanks

Marco

Thanks

Marco