Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I get my data from 2 table sources, so one is suppose is called AExpiredDate and another one is BExpiredDate
so i wish to display these two in to one instead.
for example data source A
AExpiredDate Amount
-------------------- --------------
2012/02/03 12
BExpiredDate Amount
--------------------- ---------------
2012/03/03 8
So, i wish to get my result like below
ExpiredYear Amount
------------------- ----------------
FY2012 20
The Dimention i written something like this.. :
if((Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'Y') ,'FY' & Year(Var_Tenancy_Expiry),
if(Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'N','Monthly Tenancy' ))
how am i going to merge this two different field into one?
Hope to hear from the solution..
You should concatenate the two tables. Make sure to rename the two date fields so they are named the same.
And then you should add a Master calendar where you define your Year.
Then you can create a chart to display the table you want.
HI JEFFREY,
First u should have to concatenate n rename the two field in to a single field by using alias and concatenate function.
Please find the attached qvw, hope it ll helps u.
Warm Regards,
Arun Prasadh.N.
HI This is an updated qvw.
please find the attachment.
hope it helps.
Regards,
Arun Prasadh.N.
in thi qvw ,you have 4 amounts only ...if we have 100s of amounts then what we have to do ?