how to add two fact table

[yadav_anil782]

HI experts,

i have two  table  and i'm trying to add  both for  my final stage , i'm taking transectional date is check_date  from  "payment all" table  .

. now i'm creating calender on check_date . but "invoice all" data is not showing correct  becuase transection date are missing there . i'm stuck here to data modling . plz  help to connect these both table  in single table , i attached also qvd ..

[senpradip007]

Can you upload your script and qvd?

[#3]

Hi,

If you attach the qvw it will be helpful.

[yadav_anil782]

plz check  in attachment, i have attached

[yadav_anil782]

plz check  in attachment, i have attached

[qlikmpate0]

Your attachment does not open as a qvw.

[Anonymous]

hi anil,

please attach QVW ,the one you attached is log file.

Regards

Neetha

[sasiparupudi1]

you created min/max variables but you have never used them in generating your calendar?

LOAD

07-09-2015 11:58:01: 0140       Min(CHECK_DATE) as Min_Date,

07-09-2015 11:58:01: 0141       Max(CHECK_DATE) as Max_Date

07-09-2015 11:58:01: 0142       Resident tab2

07-09-2015 11:58:01:           2 fields found: Min_Date, Max_Date, 1 lines fetched

07-09-2015 11:58:01: 0145  DROP Table tab2

07-09-2015 11:58:01: 0148  LET vMin = Peek('Min_Date',0,'tab3')

07-09-2015 11:58:01: 0149  LET vMax = Peek('Max_Date',0,'tab3')

07-09-2015 11:58:01: 0150  LET vYear_Current = Year(Today())

07-09-2015 11:58:01: 0151  LET vYear_Previous = Year(Today()) -1

07-09-2015 11:58:01: 0152  LET vMonth_Current = Month(Today())

07-09-2015 11:58:01: 0153  let vtoday = today()

07-09-2015 11:58:01: 0157  tab1:

07-09-2015 11:58:01: 0158  LOAD

07-09-2015 11:58:01: 0159      Date (40268 + IterNo()-1) as Temp_Date

07-09-2015 11:58:01: 0160       AutoGenerate (1)

07-09-2015 11:58:01: 0161       While 40268 + (IterNo()-1)<= 43302

hth

Sasi