Discussion board where members can get started with QlikView.
please chech this one.
LOAD * INLINE [
Date , number , value
2/5 , 1 , 5
10/4 , 1 , 5
12/5 , 1 , 5
'' as zero
Resident t1 where Date=peek('Date',0,'t1') Order BY Date ;
DROP Table t1;
DROP Field zero;
jep but these are just examples the date doesn't matter i just want the first delivery of a product at a location.
thx for ur answer but pls check my add under jose's/arul's comment.
and my question is what u want to with ('' as zero ) or what do u mean with this.
Let me send you the code with any changes, I've tried it and it seems to work.
Date_VD as delivery_date
where "typ" ='delivery';
Date_VD as sale_date
where "typ" ='salef';
drop table Vd_TAB;
first 1 load min(date(delivery_date),'DD/MM/YYYY') as date_min
let vMin = peek('date_min',0,'aux');
first 1 Load articlnumber,
sale_date-delivery_date as diffdate
where sale_date-delivery_date >=0 and delivery_date ='$(vMin)';
drop table temp;
it will also work "jose's/arul's comment ."
zero is new derived value..
that is not required thing.
when we are taking resident of all data of upper table. than it will not give proper data that so i was taken "NEW DERIVED VALUE"
thanks for u help again.
But now there are some locations and articles with no diffdate and delivery/sale date.
I think the problem is at first 1 load because it only seem to load the first date it finds in the table.
So i tried around with firstsortedvalue, but then qlik sense gives out errors everytime.