Set Analysis in Qlikview Straight Table expression

[Anonymous]

Hi,

I have one question regarding Qlikview Straight table expression. I want to show the straight table Dimension result based on the other field selection but I want to exclude that field selection from expression. Is it possible?

Here is a sample data.

In the attached Test.xls, I have  Director level Data. and in the Test_Alliance.xls file I have Alliance level Data.

I am trying to create a Straight table in which I want to show only those alliances in the Dimension which are linked to Agent when I make Agent selection. But at the same time I want ti ignore the Agent selection in expression and want to calculate those Alliance's total Call count  (irrespective of Agent). Is there any way to do this in Qlikview?

Thanks!

The result Should be:

Alliance	Total Call Count
A1	180
A2	430

[Anonymous]

yes, I got it. Thanks!

[Anonymous]

I have one more question regarding it.

I have added one more column in the 'Test_Alliance.xls' as 'Script_Inbound'.

and I changed my formula for 'Alliance TE%' as below:

Sum(Aggr(sum(TOTAL <ALLIANCE_CHANNEL_CATEGORY> {<SCRIPT_TYPE_INBOUND_COUNT={1}, ALLIANCE_CHANNEL_CATEGORY = p(ALLIANCE_CHANNEL_CATEGORY), SALES_REP_CENTRAL_IDENTITY, DIRECTOR_NAME, MANAGER_NAME, SUPERVISOR_NAME>}SENT_TO_CARRIER_COUNT_UNLAGGED), SALES_REP_CENTRAL_IDENTITY, ALLIANCE_CHANNEL_CATEGORY))

But when I am looking at the chart, I am getting '0' count for some of the Alliances. I believed its because I don't have 'Script_Inboud=1' for that row.

In the below image for agent2-> A2 row, I am getting '0' Alliance count. It should be 230. Is it possible to get that number for all rows.

Attaching the application.

X

fo

[sunny_talwar]

This?

Expression

Sum(TOTAL <Alliance> Aggr(sum({<Script_Inbound={1}, Alliance = p(Alliance), Agent, Director>} Sent), Agent, Alliance))

[Anonymous]

Thanks for the reply Sunny. But using that I am not getting right subtotal at the end

I am getting 535 number for all Agent.

[sunny_talwar]

This should work

=Sum(Aggr(Sum(TOTAL <Alliance>Aggr(Sum({<Script_Inbound={1}, Alliance = p(Alliance), Agent, Director>} Sent), Director, Agent, Alliance)), Director, Agent, Alliance))

And I request that you should probably open a new thread for additional request as this has already become a very complex thread and to keep it simple for future users, It would be helpful we create new thread for new requirements.

Best,

Sunny

[Anonymous]

Thanks for the reply.

I have few more queries. Let me open new thread for it. Thanks!