

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Common Date
hi i am calculating actual and budget amount
both tables having different tables. and i want to make common date for both tables
Trans_detail:
LOAD *,
date(TD_DOC_DT) as TD_DOC_DT_date;
LOAD TD_COMP_CODE & TD_MAIN_ACNT_CODE as %key,
TD_COMP_CODE,
TD_DOC_DT,
day(TD_DOC_DT) as TD_day,
month(TD_DOC_DT) as Td_month,
Year(TD_DOC_DT) as TD_YEAR,
Date(MonthStart(TD_DOC_DT),'MMM-YYYY') as yearmonths,
'Q'& Ceil(Month(TD_DOC_DT)/3) as Td_Quarter,
TD_MAIN_ACNT_CODE,
TD_DRCR_FLAG,
TD_AMT_LC_1
FROM
"C:\ProgramData\QlikTech\Documents\New folder\QVD\[Trans Detail].qvd"
(qvd);
Budget_ins:
LOAD BI_COMP_CODE & BI_LOB_CODE as %key1,
BI_COMP_CODE,
BI_DIVN_CODE,
BI_LOB_CODE,
BI_TYPE,
BI_YEAR ,
BI_MONTH,
MakeDate(BI_YEAR,BI_MONTH) as TD_DOC_DT_date,
BI_VALUE
FROM
(qvd);
Account:
LOAD ACNT_COMP_CODE & ACNT_CODE as %key,
ACNT_COMP_CODE & ACNT_FLEX_06 as %key1,
ACNT_COMP_CODE,
ACNT_CODE,
ACNT_NAME,
ACNT_SHORT_NAME,
ACNT_CATG,
ACNT_FLAG,
ACNT_TYPE,
ACNT_FRZ_FLAG,
ACNT_CR_UID,
ACNT_CR_DT,
ACNT_FLEX_01,
ACNT_FLEX_02,
ACNT_FLEX_03,
ACNT_FLEX_04,
ACNT_FLEX_05,
ACNT_FLEX_06,
ACNT_COMP_NAME,
ACNT_COMP_SHORT_NAME
FROM
(qvd);
how to make common date for both tables.
plz someone suggest
thanks
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you plz chck the app and tel me how to do that
thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jagan,
above suggestion is not giving the exact result can you please check the app and tell me what i am doing wrong
thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
any help guys


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jagan Can you please help

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you attach some sample data for all the tables?
Regards,
Jagan.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
data is too large Jagan so i am attaching qvw without reducing data. if it is not enough please let me know
thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i need budget_ins date and Trans_detail date common plz help

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Arul,
I need sample data to create datamodel, I need some hunded of rows from each table to create script.
Regards,
Jagan.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
is this ok trans_detail is too big and i dont know how to extract few rows from oracle


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
sorry use this for budget_ins
