Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try this
Sum({<Alliance = p(Alliance), Agent>} calls)
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 |
What if you use as an expression instead of dimension and then move it all the way to the front?
Cool. Its working. Thanks a lot Sunny..
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.
What would you like to see here?
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.
Here you go
Great! Thanks a lot Sunny