topic Re: Dimension={$(=Only({1} Dimension2))} in a Set-analys don´t work? in QlikView

Dimension={$(=Only({1} Dimension2))} in a Set-analys don´t work?

adam1988 — Thu, 27 Mar 2014 12:13:55 GMT

Hi,

I've got problem with set analysis in table of Bankers. They can have two kinds of relationship with client (Dealmaker, Administrator) and I need to calculate balance for both roles in one table. (I hope it's clear from attached file). I was trying to find solution and all I've learned led me to do it like this:

sum({$<Dealmaker={$(=Only({1} Banker))}>} Balance)

sum({$<Dealmaker={'$(=Only({1} Banker))'}>} Balance)

But it doesn't work. I belive it has to be easy to solve but I'm realy lost. Could you please help me?

Thx.

Re: Dimension={$(=Only({1} Dimension2))} in a Set-analys don´t work?

Anonymous — Thu, 27 Mar 2014 13:43:59 GMT

Adam, try these (I assume the only chart dimension is Banker):
sum(aggr(only(if(Banker=Administrator, Balance)), Deal_ID, Administrator, Banker))

sum(aggr(only(if(Banker=Dealmaker, Balance)), Deal_ID, Administrator, Banker))

Re: Dimension={$(=Only({1} Dimension2))} in a Set-analys don´t work?

adam1988 — Thu, 27 Mar 2014 13:56:26 GMT

Awesome, works just fine!

Thx a lot! I need to check aggr function to fully understand what you did there...but thx again.