topic Re: solve the below req? in QlikView

solve the below req?

gkcchowdary — Wed, 12 Aug 2015 10:08:06 GMT

table:

date, sales

1/1/15,100

1/3/15,200

1/5/15,300

1/7/15,400.

my requirement is 1/1/15 to 1/3/15 date b/w missing 1/2/15 date same 3 to 5 month 4 month missing

so i want missing date and witch date missing that sales replace previous sales amount.like below table

date, sales

1/1/15, 100

1/2/15,100

1/3/15,200

1/4/15,200

1/5/15,300.

Re: solve the below req?

MK_QSL — Wed, 12 Aug 2015 10:25:43 GMT

Temp:
Load
  Date(Date#(date,'D/M/YY')) as date,
  sales
Inline
[
  date, sales
  1/1/15,100
  1/3/15,200
  1/5/15,300
  1/7/15,400
];


MinMaxDate:
Load min(date) as MinDate, Max(date) as MaxDate Resident Temp;


Let vMinDate = Num(Peek('MinDate',0,'MinMaxDate'));
Let vMaxDate = Num(Peek('MaxDate',0,'MinMaxDate'));


Drop Table MinMaxDate;


Join (Temp)
Load
  Date(MonthStart($(vMinDate) + IterNo() - 1)) as date
AutoGenerate 1
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);


NoConcatenate
Final:
Load
  date,
  If(IsNull(sales) or Len(Trim(sales))=0, Peek('sales'), sales) as sales
Resident Temp
Order By date;


Drop Table Temp;

Re: solve the below req?

tyagishaila — Wed, 12 Aug 2015 10:28:39 GMT

Hi,

You can create Date field by

Load

Date(today()-RecNo(),'YYYY-MM-DD') as DataDate

Autogenerate 30;

(it will create 1 month date field)

and use previous() in your set analysis where DataDate not match to your date field,

try it,

Re: solve the below req?

kavita25 — Wed, 12 Aug 2015 10:58:26 GMT

Check the qvw