Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ch_riadh
Contributor

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

Re: Date

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

Re: Date

ok
but how can i play with the date conditions ?

Community Browser