Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have two database (old and new database).suppose database 1 have the amount up to mid of the 2015 year.
Database 2 have amount start from mid of the 2015 year.
So I have merged both database dimensions,amount etc.
Expression is:
=aggr(sum({<Flag={'B'}>}TOT_TAX_AMT),TAX_CODE)+sum({<Flag={'A'}>}aggr(only(TOTAL_REVENUE),key))
Both database sum is shown in upper expression.
You can see aggr is used in both parts of the expression. Due to 2 aggr function in the single expression, the year 2015 amount is not showing on the table. But for 2017,2016,2014,2013, the amount is coming in the report.
Note: I am not taking dimension in the table, I am only showing expression in table.
Please tell me how to sort out this problem.
Thanks,
Narender
Hi,
could it be that you just need to aggregate the first Expression:
sum(aggr(sum({<Flag={'B'}>}TOT_TAX_AMT),TAX_CODE))+sum({<Flag={'A'}>}aggr(only(TOTAL_REVENUE),key))
If DB1 and DB2 same structure and then call up using concatenate
DB1:
Select Flag, TOT_TAX_AMT, TAX_CODE, Key;
DB2:
Select Flag, TOTAL_REVENUE as TOT_TAX_AMT, Key;
Then may be this?
Aggr(Sum({<Flag = {'A', 'B'}>} TOTAL_REVENUE),Key)
Hi Johansson,
It is Showing wrong data.
Thanks,
Narender
Hi Anil,
Both db has different structure.
Thanks,
Narender
Would you share sample application
Hi Anil,
I cant share with you.Because it has multiple dimension and script created in multiple phases.
No problem. We only need the final QVW without script or DBs.