topic Re: DATE in QlikView

DATE

ch_riadh — Sun, 19 Oct 2014 10:03:34 GMT

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

Re: DATE

MarcoWedel — Sun, 19 Oct 2014 12:05:48 GMT

QlikCommunity Tip: How to get answers to your post?

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

Re: DATE

its_anandrjs — Sun, 19 Oct 2014 17:21:00 GMT

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

Re: DATE

Mon, 20 Oct 2014 07:36:39 GMT

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

Re: DATE

ch_riadh — Mon, 20 Oct 2014 09:16:33 GMT

thanks
and what about invdate ?

Re: DATE

ch_riadh — Mon, 20 Oct 2014 10:11:13 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 = "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

Mon, 20 Oct 2014 11:08:44 GMT

try like:

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

If not clear than please attach a sample app.

Thanks,

Singh