Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ch_riadh
Not applicable

DATE

STATUS <> 0  and RECDATE  <= Selected_Date

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

STATUS = "F" and RECDATE <= Selected_Date and INVDATE > Selected_Date

STATUS = "X" and RECDATE <= Selected_Date and INVDATE > Selected_Date

6 Replies
its_anandrjs
Not applicable

Re: DATE

Please ask your question clearly with informative way if possible provide any sample data or file otherwise any community member not properly give answer to your question.

Regards,

Anand

Not applicable

Re: DATE

You can either use this using IF statements or using set analysis in expressions.

1) If statements

sum(if(STATUS <> 0  and RECDATE  <= Selected_Date,Sales))

2) Set analysis

sum({<STATUS-={0},RECDATE={"selectedate"}>}Sales)  * RECDDATE and selecteddate must be in same format.

Thanks,

Singh

ch_riadh
Not applicable

Re: DATE

thanks
and what about invdate ?

ch_riadh
Not applicable

Re: 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 = "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.

Not applicable

Re: DATE

try like:

count({<{STATUS={"I"},RECDATE = {"<=$(=max(SelectedDate))"} ,INVDATE = {">$(=max(SelectedDate))"}}>}Stockid)

If not clear than please attach a sample app.

Thanks,

Singh