Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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".
@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.
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.
@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.