Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

General Dates and DM Query

Hello Experts,

I am working on an application, where in Calendar Table the datekey is coming from SQL and its like 77463 format as its a key and in the same master calendar I have the YearMonth dimension in the format of 2011-07. I have an external excel sheet with below data which I am trying to link to my data model master calendar. I am trying something like Join load any suggestions please?

YearMonthExpenses
2011-038,114.20
2011-042,859.15
2011-055,222.29
2011-067,237.46
2011-074,979.86


After I load this data, it shows me as 42350 instead of the series of numbers as 77463 and I tried changing the data format in Excel to DD/MM/YYY but that doesnt help.

I want to link this data to my master calendar for the expenses to use across the application any help please..

Thanks,

Mady

1 Reply
Highlighted
Not applicable

General Dates and DM Query

Hello Mady,

if I got you right, your master cal is based on days. Its key is a number representing one day - let's call it a DayDate. Your excel-data comes with a date based on month as the expenses are per month. So I would transform the YearMonth into a DayDate concatenating a '-01' to YearMonth. May be you have to calculate(transform, reformat, ....) this DayDate into the according number of your master calender key. After this you have a valid key to link your excel data (now based on a DayDate) to your master cal using eg. left join.

After this all your reports sholud work as expected.

HtH

Roland