How to show data results from a table that links to a query on another table.
Good morning, I am pretty new to Qliksense and I have difficulties in obtaining some results from a series of Dimensions. I'll try to explain the challenge I am facing.
I have
1 Dimension that contains a series of reference numbers (Transactions reference)
1 Dimension that contains invoice details (charge codes)
1 Dimension that contains invoice numbers
I need to extract the reference numbers that are linked to 1 or more invoices that DO NOT contain a specific Charge Code/s (XYW) but contains many others.
I am unable to find a way to "eliminate" from the report the invoices that contains the specific charge code and are linked to their relevant reference number.
The end result would be to see only the reference numbers that are linked to invoices that DO NOT contain the specific charge code.
The typical way to exclude certain values would be with Set Analysis. Assuming your charge code field is named "ChargeCode", your set would look like this:
{<ChargeCode-={'XYW'}>}
You must use the set within an aggregation function, something like sum() or count(). Exactly what function depends on your display requirement. For example, if you wanted a table of Invoices and a list of Transaction References for each you could use a Dimension of InvoiceNumber and a measure of:
The typical way to exclude certain values would be with Set Analysis. Assuming your charge code field is named "ChargeCode", your set would look like this:
{<ChargeCode-={'XYW'}>}
You must use the set within an aggregation function, something like sum() or count(). Exactly what function depends on your display requirement. For example, if you wanted a table of Invoices and a list of Transaction References for each you could use a Dimension of InvoiceNumber and a measure of:
