topic Show single overall average value for a selected Dim in QlikView

Show single overall average value for a selected Dim

regowins — Thu, 03 Apr 2014 17:30:28 GMT

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

Territory	Count([Note#])	Count ({<Territory=>} TOTAL [Notification #])	Count ({<Territory=>} DISTINCT TOTAL Territory)	Overall Territory Avg
	720	720	12	60
Z011	72	720	12	60
Z012	67	720	12	60
Z013	30	720	12	60
Z014	56	720	12	60
Z015	112	720	12	60
Z016	57	720	12	60
Z017	64	720	12	60
Z018	44	720	12	60
Z019	47	720	12	60
Z020	92	720	12	60
Z021	49	720	12	60
Z022	30	720	12	60

Currently if I select only Z014

Territory	Count([Note#])	Count ({<Territory=>} TOTAL [Notification #])	Count ({<Territory=>} DISTINCT TOTAL Territory)	Territory Avg
	0	720	12	60
Z011	0	720	12	60
Z012	0	720	12	60
Z013	0	720	12	60
Z014	56	720	12	60
Z015	0	720	12	60
Z016	0	720	12	60
Z017	0	720	12	60
Z018	0	720	12	60
Z019	0	720	12	60
Z020	0	720	12	60
Z021	0	720	12	60
Z022	0	720	12	60

I would like it to be like this Z014

Territory	Count([Not#])			Territory Avg
		720	12	60
Z014	56	720	12	60

Re: Show single overall average value for a selected Dim

its_anandrjs — Thu, 03 Apr 2014 17:46:25 GMT

Remove Territory= from all expression.

Re: Show single overall average value for a selected Dim

swuehl — Thu, 03 Apr 2014 17:48:34 GMT

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

Re: Show single overall average value for a selected Dim

its_anandrjs — Thu, 03 Apr 2014 17:51:29 GMT

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.

Re: Show single overall average value for a selected Dim

regowins — Thu, 03 Apr 2014 19:22:40 GMT

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!

Re: Show single overall average value for a selected Dim

regowins — Thu, 03 Apr 2014 19:26:02 GMT

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.

Re: Show single overall average value for a selected Dim

Thu, 03 Apr 2014 19:28:30 GMT

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.