topic Re: Qlikview Pivot table Set Analysis and Aggregation in QlikView

Qlikview Pivot table Set Analysis and Aggregation

Anonymous — Fri, 05 Jan 2018 02:28:40 GMT

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!

Re: Qlikview Pivot table Set Analysis and Aggregation

sunny_talwar — Fri, 05 Jan 2018 02:57:59 GMT

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

Re: Qlikview Pivot table Set Analysis and Aggregation

Anonymous — Mon, 08 Jan 2018 21:49:06 GMT

Thank you Sunny. Its working as expected.