Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ch_riadh
Partner - Creator II
Partner - Creator II

Date

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    )

or

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

;

2 Replies
Gysbert_Wassenaar

(     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


talk is cheap, supply exceeds demand
ch_riadh
Partner - Creator II
Partner - Creator II
Author

ok
but how can i play with the date conditions ?