topic 2 aggr function in single expression in QlikView

2 aggr function in single expression

narender123 — Mon, 27 Mar 2017 09:36:44 GMT

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

Re: 2 aggr function in single expression

stabben23 — Mon, 27 Mar 2017 10:07:53 GMT

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))

Re: 2 aggr function in single expression

Anil_Babu_Samineni — Mon, 27 Mar 2017 10:13:35 GMT

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)

Re: 2 aggr function in single expression

narender123 — Mon, 27 Mar 2017 10:40:17 GMT

Hi Johansson,

It is Showing wrong data.

Thanks,

Narender

Re: 2 aggr function in single expression

narender123 — Mon, 27 Mar 2017 10:40:52 GMT

Hi Anil,

Both db has different structure.

Thanks,

Narender

Re: 2 aggr function in single expression

Anil_Babu_Samineni — Mon, 27 Mar 2017 10:42:58 GMT

Would you share sample application

Re: 2 aggr function in single expression

narender123 — Mon, 27 Mar 2017 11:09:08 GMT

Hi Anil,

I cant share with you.Because it has multiple dimension and script created in multiple phases.

Re: 2 aggr function in single expression

Peter_Cammaert — Mon, 27 Mar 2017 11:38:18 GMT

No problem. We only need the final QVW without script or DBs.