Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

Dates Mapping to Actual Database

     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.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Dates Mapping to Actual Database

See this blog post: How to populate a sparsely populated field


talk is cheap, supply exceeds demand

View solution in original post

10 Replies
Highlighted
MVP
MVP

Re: Dates Mapping to Actual Database

Can you be more specific in your question?

If possible provide sample file or apps to understand help you better.

Highlighted
Not applicable

Re: Dates Mapping to Actual Database

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Dates Mapping to Actual Database

See this blog post: How to populate a sparsely populated field


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist II
Specialist II

Re: Dates Mapping to Actual Database

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

Highlighted
Master II
Master II

Re: Dates Mapping to Actual Database

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;

Highlighted
Specialist II
Specialist II

Re: Dates Mapping to Actual Database

Realy i uderstand somthing Gysbert but henric defined only dates b/w one column what incase have  multiple columns

for that how to genarate.

Highlighted
MVP
MVP

Re: Re: Dates Mapping to Actual Database

Check this ... it is about filling missing data for multiple field.

Highlighted
Specialist II
Specialist II

Re: Dates Mapping to Actual Database

Thanks Manish its helped me .

Highlighted
MVP
MVP

Re: Re: Dates Mapping to Actual Database

Use this file... It's very interesting and also related to you topic.