topic Date in QlikView

Date

ch_riadh — Mon, 20 Oct 2014 09:48:26 GMT

LOAD

Status,

Stockid,

Model,

RECDATE,

INVDATE

FROM

(qvd) ;

My Customer want to show the Available Stock till the date selected.
with this Condition :

( STATUS <> 0 and RECDATE <= Selected_Date )

( STATUS = "I" and RECDATE <= Selected_Date and INVDATE > Selected_Date )

For example :
if i select ( march/2014),

i need to see : the stock available stock from 1900 til 31/03/2014.

and if a car received on 20/03/2014 and invoiced on 02/04/2014 -----> i have to show it.

but if a car received on 20/03/2014 and invoiced on 28/03/2014 -----> i dont want to show it.

;

Re: Date

Gysbert_Wassenaar — Mon, 20 Oct 2014 10:03:11 GMT

( STATUS <> 0 and RECDATE <= Selected_Date )

or

( STATUS = "I" and RECDATE <= Selected_Date and INVDATE > Selected_Date )

These conditions don't make sense. Status I is not 0 so the first condition will always apply to status I. Your second condition of the OR will never be tested

Re: Date

ch_riadh — Mon, 20 Oct 2014 10:10:20 GMT

ok
but how can i play with the date conditions ?