Set analysis on null

alex59800 — Mon, 08 Feb 2016 14:50:34 GMT

Hello All,

i have this table below

DATE CREATION = order date

N° commande = order number

Date facture = Invoice date

N°facture = invoice number.

DATEMAX=variable on my maximum invoice date

FLAG= -1 for credit note and 1 for invoice

ASKAPO = product Bookmark

vActualYear= variable setting actual year

I have order not invoiced at all yet (as order 150060394)

I have order invoiced but with an order single line not invoiced (see above last order 150061016 with 2893€ invoiced and 65 € not invoiced).

My problem :

I would like to have a real order book without those not invoiced lines. Invoiced status is on the invoice header (partly not invoiced order where an invoice number exists like above order 150061016).65€ not invoiced but order already invoiced with 2893€ invoiced .

above 65€ have no invoice number. Answer = -

- is supposed to be null ?

what i need : all order that have not been invoiced even partly (my problem) from 01/09/2014 to today minus one year 05/02/2014 (not problem on that last point) in that case = 2865+1869

My expression below need to be corrected in set analysis.

=Sum({ASKAPO*<[DATE CREATION]={">=$(=makedate(vActualYear-1,9,1)) <=$(=makedate(vActualYear,num(month(max([DATEMAX]))),num(day(max([DATEMAX])))))"}>}[CA Net cde]*FLAG)

Thxs a lot

topic Set analysis on null in QlikView

Set analysis on null