Qlikview Pivot table Set Analysis and Aggregation

[Anonymous]

Hi,

I am using set analysis in the Pivot chart. and also ignoring the selection of one column. But I am not getting correct values.

Attaching the application.

In 'Alliance Sent Check' column, I am trying to get Alliance Total Call count by ignoring the agent. Also I am trying to add ' Script_Inbound=1' in set analysis. But for those agents who has script_Inbound=0, I am getting '0' count in 'Alliance Sent Check' column. I tried using below formula (suggested by stalwar1‌)  but in that case when I am selecting any agent, it doesnt show me correct values.

Attaching the files and application.

Thanks!

[sunny_talwar · Accepted solution]

May be try this

=Sum(Aggr(Sum(TOTAL <Alliance> {<Agent, Director>}

Aggr(Sum({<Script_Inbound={1}, Alliance = p(Alliance),

Agent, Director>} Sent),

Director, Agent, Alliance)),

Director, Agent, Alliance))

[Anonymous]

Thank you Sunny. Its working as expected.