Set Analysis in a simple table

[FranciscoQ]

Hi

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".

[Or]

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.

[sidhiq91 · Accepted solution]

@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.