When you add a CQL navigation element to the SubSpace Navigation, you can use Metadata sets and fields in your query (see section "Using Confluence Query Language (CQL) Syntax in Macros (Expert Filter Criteria)" of page Searching with Metadata in the Metadata for Confluence user guide).
Examples
Error rendering macro 'excerpt-include' : No link could be created for 'KB:METADATA:Examples for CQL expert filter criteria (v 3.3)'.