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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate way of set analysis

Hello,

I am using the below set analysis to give me the number of departments without any employee where in the dept.city is LN or NY.

=count({<DEPT_ID=e({<E_ID={*}>}DEPT_ID),City={'NY','LN'}>}DEPT_ID)

However, while using the same expression in Charts, I am unable to make proper selection of dimensions.

Is there any alternate way to represent this without set analysis, so that I can use it in my charts?

Thanks,

Sindhu.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, I'm afraid you're stuck with improper selections only.


talk is cheap, supply exceeds demand