Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Column for the opposite of what i have selected

Hi 


Really hoping someone can help. 

I am able to filter by certain areas and concatenate their Type and Value into a column as follows:-

=concat (distinct[Activity Service Area Type] & '- ' & [Activity Service Area Value],', ')

But what i cant work out is to show the negative of this in a new column (ie the remaining values that havnt been selected).

Can anyone help please

Thanks

2 Replies
Highlighted

Use Exclude (E(Field Name)) in set analysis

Assuming that Activity Service Area Type field is used for selections

=Concat (distinct {<[Activity Service Area Type]=E([Activity Service Area Type])>} [Activity Service Area Type] & '- ' & [Activity Service Area Value],', ')

Highlighted
Contributor
Contributor

Thank you Celambarasan that worked perfectly.  Really appreciated 🙂