topic Re: Join two tables with different date types in QlikView

Join two tables with different date types

anuradhaa — Tue, 22 Jul 2014 11:35:19 GMT

HI,

I have a table and it has date as YYYY-MM-DD.I'm using calendar thing too.

but in every month i need to add additional records to that table. So i have only month and year.

generally in month data i'm adding summary records.

Can anyone tell me how to handle this problem.

Thank you

Re: Join two tables with different date types

avinashelite — Tue, 22 Jul 2014 11:40:42 GMT

Hi Anuradha,

Since you have master calender, link the date field with the master calender date by renaming.

If ur facing issue please upload the app

Re: Join two tables with different date types

MK_QSL — Tue, 22 Jul 2014 11:41:35 GMT

Not understood completely from your description.. Can you elaborate little more with an example or sample...

Re: Join two tables with different date types

ramasaisaksoft — Tue, 22 Jul 2014 12:26:13 GMT

Hi Anuradha,

Can u please elaborate.I didn't understand u r problem.

Re: Join two tables with different date types

anuradhaa — Wed, 23 Jul 2014 11:30:03 GMT

Here i have data for sales

CUSTOMER	RDATE_TIME	Sales
A	1/2/2005	20,578
B	2/2/2005	20,373
C	3/2/2005	22,381
D	4/2/2005	21,042

So i get these data from data base. Then i have use a calender and have Year,Month, Day list boxes. To view data based on selection.

Here i have use drill down group year,month,day.

suddenly i get monthly data from one Customer. I need to add them to this report. Then i have put that data in excel and join it with my existing table. the problem i have is i don't have date for my summary data.

I can use date in that month, but then all moth data display under that date. Is there a way to solve this.

Thanks