Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all
I have data excel loaded into qv in that data have some missing dates so i created dynamically dates .my question is how to map that dyanamically created dates to actual Data.
See this blog post: How to populate a sparsely populated field
Can you be more specific in your question?
If possible provide sample file or apps to understand help you better.
See Henric's blogs, you will find how to create a master calendar.
You need to create a table (master calendar) where you will have all the dates between the 1st and the last one of your data. For each date, you can compute many informations like the week day, the month, the Year, the YTD (or not) etc. Everything that will be useful in the UI
Fabrice
See this blog post: How to populate a sparsely populated field
Hi Sunil,
Please find link,
http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field
it will help you.
- Regards
Vishal Waghole
Create a ,aster calendar and link it with you actual date field making associative link to write the same name of that field like
// Calender
LET vDateMin = Num(MakeDate(2006,1,1));
LET vDateMax = Floor(DayEnd(Today()));
TempCalendar:
LOAD
date($(vDateMin) + RowNo() -1) AS DateNumber ,
Date($(vDateMin) + RowNo() -1) AS TempDate ,
AUTOGENERATE 1
WHILE $(vDateMin)+IterNo()<= $(vDateMax);
Calendar:
LOAD
Date(TempDate,'DD-MM-YYYY')as Date,
num(date(TempDate,'DD-MM-YYYY'))as num,
DayName(TempDate)as Day,
Day(TempDate) AS CalendarDayOfMonth,
YearName(TempDate,0,2)as FiscalYear,
Year(TempDate) AS YTD,
Month(TempDate) AS CalendarMonthName,
'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter,
MonthStart(TempDate) as CalendarMonthStart,
QuarterStart(TempDate) as CalendarQuarterStart,
num(month(TempDate))as num_month,
YearStart(TempDate) as CalendarYearStart,
MonthEnd(TempDate) as LMTD,
QuarterEnd(TempDate) as LQTD,
(Date#(TempDate,'DD-MM-YYYY'))as Current_date,
YearEnd(TempDate) as LYTD
RESIDENT TempCalendar ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
Realy i uderstand somthing Gysbert but henric defined only dates b/w one column what incase have multiple columns
for that how to genarate.
Check this ... it is about filling missing data for multiple field.
Thanks Manish its helped me .
Use this file... It's very interesting and also related to you topic.