Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

poonam21
New Contributor III

Qlikview Pivot table Set Analysis and Aggregation

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!

1 Solution

Accepted Solutions

Re: Qlikview Pivot table Set Analysis and Aggregation

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


Capture.PNG

View solution in original post

2 Replies

Re: Qlikview Pivot table Set Analysis and Aggregation

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


Capture.PNG

View solution in original post

poonam21
New Contributor III

Re: Qlikview Pivot table Set Analysis and Aggregation

Thank you Sunny. Its working as expected.