Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
regowins
Creator II
Creator II

Show single overall average value for a selected Dim

Hi,
I currently have a chart that shows the count of notifications  by territory and the overall avg notification count by  territories. However, if I select 1 or 2 territories I only want to see their counts and the overall avg.  I don't want the overall avg for the unselected territory. I want to see only one territory(count and overall territory avg) in my  chart.

Thanks!

no selections

TerritoryCount([Note#])Count
  ({<Territory=>}  TOTAL
  [Notification #])
Count
  ({<Territory=>} DISTINCT TOTAL Territory)
Overall Territory Avg
7207201260
Z011727201260
Z012677201260
Z013307201260
Z014567201260
Z0151127201260
Z016577201260
Z017647201260
Z018447201260
Z019477201260
Z020927201260
Z021497201260
Z022307201260

Currently if I select only Z014

TerritoryCount([Note#])Count
  ({<Territory=>}  TOTAL
  [Notification #])
Count
  ({<Territory=>} DISTINCT TOTAL Territory)
Territory Avg
07201260
Z01107201260
Z01207201260
Z01307201260
Z014567201260
Z01507201260
Z01607201260
Z01707201260
Z01807201260
Z01907201260
Z02007201260
Z02107201260
Z02207201260

I would like it to be like this  Z014

TerritoryCount([Not#]) Territory Avg
7201260
Z014567201260
6 Replies
its_anandrjs

Remove Territory= from all expression.

swuehl
MVP
MVP

Could you post a small sample application? Seems to work in my attached sample (not using your data model, since I don't know it).

its_anandrjs

From any one expression   like 


Count ({<Territory=>}  TOTAL [Notification #])  in place of this use


Count ( TOTAL [Notification #]) because by using Territory= it will bypass the field selection.



regowins
Creator II
Creator II
Author

Interesting it works in  your test app. At least I know I am on the write path. Not sure if I can post the sample app though.

Thanks!

regowins
Creator II
Creator II
Author

It did not work.  I used Territory =  becuase I want to bypass the selection for the overall avg so it stays constant, regardless of which territory selection I pick.

Thanks for the help.

Not applicable

Just remove {<Territory=>}  and  TOTAL from your expressions.

{<Territory=>} ignores any selection in Territory field and TOTAL ignores chart dimensions. What I understand from your question, you don't need both of them.