topic Re: Sales Order Date in QlikView

Sales Order Date

Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have the following Dimensions:

1. Item Type:

=if (Match([Transactions.Item Type], 'ServiceItem', 'InventoryItem', 'InventoryAssemblyItem', 'NonInventoryItem', 'OtherChargeItem', 'DiscountItem') and

Match([Transactions.Txn Type], 'Invoice','Sales Receipt', 'Credit Memo', 'Charge', 'ARRefundCreditCard', 'Sales Order'), [Transactions.Item Type])

2. Txn Type:

=if(([Transactions.Inventory Table] = 0) and (Transactions.Pending = 0 or IsNull(Transactions.Pending)) and Match([Transactions.Txn Type], 'Sales Order'), [Transactions.Line Items Txn Type])

I'd like to pull the following expression: [Transactions.Sales Order Number] but it's giving me a null value. I have nothing filtered and there are sales order numbers, so I'm wondering what going on?

Thanks for your help,

Re: Sales Order Date

vishsaggi — Mon, 19 Jun 2017 20:38:55 GMT

Where you getting this Null value? In a chart or in a Text Object and what expression you are using?

Re: Sales Order Date

Mon, 19 Jun 2017 20:48:30 GMT

What type of chart?

Re: Sales Order Date

sunny_talwar — Mon, 19 Jun 2017 22:41:59 GMT

Are you counting the [Transactions.Sales Order Number]? May be use Count() function

Count([Transactions.Sales Order Number])

Re: Sales Order Date

Colin-Albert — Tue, 20 Jun 2017 10:01:48 GMT

Are you using any aggregation in your expression?

If no aggregation is used then Qlik will evaluate the expression using only()

So [Transactions.Sales Order Number] will be evaluated as Only( [Transactions.Sales Order Number] )
Only will return null if more than one value exists

Either add [Transactions.Sales Order Number] as a dimension, or use an aggregation such as max() or maxstring()

Re: Sales Order Date

Tue, 20 Jun 2017 17:32:15 GMT

Thanks - I'm using a straight table. I've tried the dimensions and then max() and the maxstring() but it doesn't seem to work. Is there anything else I should add so that I can see the sales order number for a given day?

Thanks again,