topic Re: Calculated Dimension in QlikView

Calculated Dimension

upaliwije — Mon, 09 Sep 2019 08:37:21 GMT

Dear Friends

I have written below calculated dimension in my pivot table of my Qv Doc

=if(aggr(sum({<CRE_PAID_AMOUNT={">=0"}>},RISK))=6,count(DISTINCT RISK),dual('6',1),
if(aggr(sum({<CRE_PAID_AMOUNT={">=0"}>},RISK))=10,count(DISTINCT RISK),dual('10',2)))

But it does not work. Pls correct me where I am wrong

Re: Calculated Dimension

Vegar — Mon, 09 Sep 2019 08:49:13 GMT

You are missing to point out for which dimensions you want to aggregate your data. Aggr() takes more than one parameter.

Aggr(expr, StructuredParameter{, StructuredParameter})

Aggr(sum({<CRE_PAID_AMOUNT={">=0"}>},RISK), #MISSING# )

Re: Calculated Dimension

upaliwije — Mon, 09 Sep 2019 09:46:47 GMT

Thanks for your reply. But is is not clear to me

Re: Calculated Dimension

Vegar — Mon, 09 Sep 2019 14:39:18 GMT

You are trying to aggregate sum({<CRE_PAID_AMOUNT={">=0"}>},RISK) but you are not stating over which dimension you want to aggregate.

You could try to see if you really need the aggr. Try

=if(sum({<CRE_PAID_AMOUNT={">=0"}>},RISK)=6,count(DISTINCT RISK),dual('6',1),
if(sum({<CRE_PAID_AMOUNT={">=0"}>},RISK)=10,count(DISTINCT RISK),dual('10',2)))

Re: Calculated Dimension

upaliwije — Mon, 09 Sep 2019 16:26:02 GMT

It is not working my friend,Thanks for your help

Re: Calculated Dimension

Brett_Bleess — Tue, 08 Oct 2019 13:41:58 GMT

Have a look at the following Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833

There are others on AGGR as well, here is the base link to where you can search on the others if the one above is not what you need.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett