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

[sunny_talwar · Accepted solution]

Try this

Sum({<Alliance = p(Alliance), Agent>} calls)

[Anonymous]

Thank you Sunny.

I have one more question.  is it possible to use 'Agent' as a dimension with the above expression.

Is there any way to get the below result.

Agent	Alliance	Call  Count
agent1	A1	180
agent1	A2	430

[sunny_talwar]

What if you use as an expression instead of dimension and then move it all the way to the front?

[Anonymous]

Cool. Its working. Thanks a lot  Sunny..

[Anonymous]

When I select agent1 and agent2 together, I get the below result. Is it possible to show All agents with the above expression.

Because now when I clear the selection, I am getting null values for Agents.

and if more than one agent is linked to same Alliance, it doesn't show those records separately. instead it shows '-' value.

[sunny_talwar]

What would you like to see here?

[Anonymous]

When I click on 'Director A' , I will get agent1, agent2 and agent3 associated with Director 'A'.

So when I click 'Direcror 1', I would like to see all agents under him with the below result.

[sunny_talwar]

Here you go

[Anonymous]

Great!  Thanks a lot Sunny