DATE

[ch_riadh]

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

[MarcoWedel]

QlikCommunity Tip: How to get answers to your post?

Its not about the answer, rather it’s about the question…

[its_anandrjs]

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

[#4]

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]

thanks
and what about invdate ?

[ch_riadh]

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.

[#7]

try like:

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

If not clear than please attach a sample app.

Thanks,

Singh