topic Filtering vs mutually exclusive in App Development

Filtering vs mutually exclusive

dwighttrumbower — Fri, 23 Aug 2019 15:43:26 GMT

When using filters, the backend seem to use and OR to filter the data. Is there a way to make it an AND?

If I where to select on the Feature filter of 5th Wheel and Accessories, the table that I display would show all invoices that have at least one of the options. I want to show invoices that only have those options.

Thanks

Re: Filtering vs mutually exclusive

Vegar — Fri, 23 Aug 2019 19:02:16 GMT

My guess is that what you are asking for is supported by the qlik sense qix engine hence it is a feature in QlikView. AND mode in List Boxes I have however not seen anything written about this for qlik sense by Qlik nor the open source extension community.

I have however seen a workaround to accomplish similar behaviour in Qlik Sense, take a look at this community thread posted by @JonnyPoole .

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Generating-AND-OR-NOT-selection-logic-in-Qlik-Sense/ta-p/1479510

Re: Filtering vs mutually exclusive

dwighttrumbower — Fri, 23 Aug 2019 19:09:18 GMT

Thanks for the reply. I would think an analytical tool would do more than just than the associate type of filtering.

My users want to ask questions like: "How many orders did we have with feature 1 and feature 2 and feature 3? " With my limited knowledge of Qlik Sense, I don't see an easy way to show this.

Thanks

Re: Filtering vs mutually exclusive

Vegar — Fri, 23 Aug 2019 19:55:37 GMT

Doesn't the last link I posted help you to do what you want?

Re: Filtering vs mutually exclusive

dwighttrumbower — Fri, 23 Aug 2019 19:57:21 GMT

I'm looking into it.