Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want to create this expression:
If Status = {'A'} and Received_date_field > vSelectDate and Invoiced_date_field < vSelectDate , Count (StockID)
vSelectDate is a variable : Max(Received_date_field)
Please need help emergency
Thanks
sorry From 1988
Hi,
Basically what I understand is you need data from starting till month end of selected year and month.
Correct me if I misunderstood something
Regards
ASHFAQ
yes
So give me the available stock.
if i select for example March 2012.
you have to give me all data till 31/03/2012
with this condition : Invoice_Date > Selected date.
Hi,
You need to create one common date for that have a look at below post
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
Then try below
vSelectDate= monthend(Max(Received_date_field))
Count({$<Status = {'A'},[CommonDate]={"<=$(vSelectDate)"}>} [StockID])
Regards
ASHFAQ
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.
rec_date < vSelectedDate and inv_date < vvSelectedDate