Sales Order Date

[#1]

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,

[vishsaggi]

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

[#3]

What type of chart?

[sunny_talwar]

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

Count([Transactions.Sales Order Number])

[Colin-Albert]

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()

[#6]

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,