How to show values greater than 1 and not in PRD

[tmumaw]

I have a straight table and I only want to display Objects that are on more than 1 transport and not in PRD.  So what I have done so far is create a straight table with Object and then I counted the number of transports the object appears on.  I only want to display the ones where the transport count is greater than 2 and length of PRD indicator is 0.

Thanks

[lockematthewp]

Create a synthetic dimension like:

=if (count(distinct [Transport]) > 2 and len([PRD]) = 0, [Object])

[lockematthewp]

and be sure to check 'Suppress When Value Is Null'

[tmumaw]

Here's my statement 

=if(count(distinct [QAS_TRKORR]) > 2 and [Ind] = 0, [QAS_OBJ_NAME])

I'm getting this as a dimension:

// Error in Calculated dimension.

[Brett_Bleess]

Hey Thom, long time no talk, hope all is well! 🙂  I am not much help on where the other poster was taking you, but I thought the following might be another avenue potentially...

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

That Design Blog area is a good source of ideas in case you did not know it was there, cannot recall if I had told you about that previously or not.  My post should kick things back up to the front again as well, so someone else may chime in again with other ideas too.  Take care!

Cheers,
Brett