Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD Category,
Loc,
mon,
tar_qty,
year,
ITPCDE,
ITPFCN,
ITPTCN,
fs1,
fs2,
fs3,
fs4,
fs5,
fs6,
fs7,
fs8,
fs9,
fs10,
fs11,
fs12,
fs13,
fs14,
ts1,
ts2,
ts3,
ts4,
ts5,
ts6,
ts7,
ts8,
ts9,
ts10,
ts11,
ts12,
ts13,
ts14,
FROM
(qvd);
I want to make another column using below part. i make fsize as a global variable.
IF fs1>0 then
fsize= fs1
ELSEIF fs2>0 then
fsize= fs2
.................
hi SALTO,
i have to select TRA_DATE= currentdate because i want the data to today
LOAD
TRA_LOC as Loc,
TRA_DATE,
SUM(TRA_QTY) as Total,
SUM(TRA_QTY1) as size1,
SUM(TRA_QTY2) as size2,
SUM(TRA_QTY3) as size3,
SUM(TRA_QTY4) as size4,
SUM(TRA_QTY5) as size5,
SUM(TRA_QTY6) as size6,
SUM(TRA_QTY7) as size7,
SUM(TRA_QTY8) as size8,
SUM(TRA_QTY9) as size9,
SUM(TRA_QTY10) as size10,
SUM(TRA_QTY11) as size11,
SUM(TRA_QTY12) as size12,
SUM(TRA_QTY13) as size13,
SUM(TRA_QTY14) as size14,
TRA_CAT as Category
you can provide a where condition as
date(Tran_date)=today();
or if you dont want to filter out the data, then
add a trigger on a sheet to select the current date as
Add Action> Select in Field>> tran_date,>>
today()
Hi,
you need to set up a Master Calendar on which one of the fields is DateID, with all dates from 48 months: before for example:
Let StartDate = num(date(YearStart(AddMonths(Today(),-48,0)),'YYYYMMDD'));
Let EndDate = num(date(YearEnd(AddMonths(Today(),0,0)),'YYYYMMDD'));
Calendar:
Load *,
Year(Date) AS [Year],
Month(Date) AS [Month],
num(Month(Date)) AS [MonthNum],
Day(Date) AS [Day],
Year(Date)&num(Month(Date),00) as [Year Month],
Load Date($(StartDate)+(Iterno()-1),'YYYYMMDD') as Date,
Date($(StartDate)+(Iterno()-1),'YYYYMMDD') as DateID
Autogenerate 1 While Date($(StartDate)+(Iterno()-1)) <=Date($(EndDate)
Then load the second table:
Data:
TRA_DATE as DateID
Hope this helps.
ok i ll try. thanks
thanks for ur help
