topic Set Analysis in a simple table in App Development

Set Analysis in a simple table

FranciscoQ — Mon, 18 Jul 2022 19:28:24 GMT

Let's say I have a simple table with: OrderID, DocumentType and Sale:

If I create a simple table in Qlik with ORDER ID and a Metric like SUM({<DOCUMENTTYPE = {"C"}>}SALE)

The table is going to display only the ORDER ID's related to "C" documents ? Or is going to display all the orders and will only summarize the ones related to "C".

Re: Set Analysis in a simple table

Or — Mon, 18 Jul 2022 21:12:48 GMT

Only order IDs related to C should be displayed. This should be easy enough to check - do it yourself with an inline load and a table. Note that for the literal C you should use {'C'} with single quotes, rather than double quotes.

Re: Set Analysis in a simple table

sidhiq91 — Tue, 19 Jul 2022 04:54:26 GMT

@FranciscoQ as @Or mentioned only Orders related to C will be displayed. Please see the Screen shot attached.

If this resolves your issue, please like and accept it as a solution.