topic Re: Qlik Sense - Need Help with Exclude Expression in App Development

Qlik Sense - Need Help with Exclude Expression

Mon, 05 Dec 2016 15:04:55 GMT

I am trying to build a visualization based on a recordID which does NOT include certain keyword topics. I have a set of recordID's which are associated to various Topics. The issue is I would like to display the recordID's which are NOT associated to a specific topic. For example, display the recordID's which are NOT associated to the topic of Disclosure (see attached screenshot). I'm able to get a count of those records, but I need to be able to select the data and export the recordID's. So far I've only been able to get a count of the records, but not the actual recordID's.

Re: Qlik Sense - Need Help with Exclude Expression

Anonymous — Mon, 05 Dec 2016 16:49:25 GMT

Looks like a candidate for not equal to in Set analysis.

Just did a quick search on that and this was the first hit Set Analysis - "Does not equal"

Don't worry that it is a QlikView thread as the Set Analysis functionality is identical View vs Sense.

Re: Qlik Sense - Need Help with Exclude Expression

Mon, 05 Dec 2016 17:43:33 GMT

Thanks Bill. The issue here is we don't know which Topic the user selected. For example, if they click on the Disclosure Topic in the first chart we don't know how to exclude based on the user selected topic. Hopefully that makes sense.

Re: Qlik Sense - Need Help with Exclude Expression

Anonymous — Mon, 05 Dec 2016 17:51:44 GMT

In that case you may need to use P() or E().

Have a look at this Blog Post by Henric, that also references some other useful posts.

A Primer on Set Analysis

Re: Qlik Sense - Need Help with Exclude Expression

Anonymous — Mon, 05 Dec 2016 21:22:31 GMT

Maybe this is what you are looking for...from the QS help on Set analysis:

sum( {1-$} Sales )

Returns sales for everything excluded by the selection.