topic Re: Compare County to State Average in QlikView https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517173#M193076 <HTML><HEAD></HEAD><BODY><P>Your attached screenshot is not helping much in understanding your issue. Could you post a small sample application?</P><P></P><P>If you include all fields the user may perform a 'lower selection' in as shown above, the avg should not change. But maybe I am missing something else.</P></BODY></HTML> Thu, 12 Sep 2013 18:03:16 GMT swuehl 2013-09-12T18:03:16Z Compare County to State Average https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517170#M193073 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm trying to add a reference line to a gauge chart which show the state average and allow comparison for the regions selected below the state (country, municipality, zip, etc.). I have attached a sample image.</P><P></P><P></P><P>The problem is I'm a little rusty with set analysis.&nbsp; I can't keep the static total for a state in any of my calculations - once I select the level below state, the total for state drops as well.&nbsp; Can anyone help refresh my memory on this?</P><P></P><P></P><P>Thanks in advance!</P></BODY></HTML> Thu, 12 Sep 2013 17:49:31 GMT https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517170#M193073 2013-09-12T17:49:31Z Re: Compare County to State Average https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517171#M193074 <HTML><HEAD></HEAD><BODY><P>You probably need to ignore selections in these fields, so maybe like</P><P></P><P>=avg({&lt;CountryField=, MunicipalityField= ,ZipField= &gt;} Value)</P></BODY></HTML> Thu, 12 Sep 2013 17:53:31 GMT https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517171#M193074 swuehl 2013-09-12T17:53:31Z Re: Compare County to State Average https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517172#M193075 <HTML><HEAD></HEAD><BODY><P>Thanks - that helps refresh my memory.&nbsp; I tried that but I'm s<SPAN style="font-size: 10pt; line-height: 1.5em;">till having the totalling issues - the totals that come back are limited by the lower selections.</SPAN></P></BODY></HTML> Thu, 12 Sep 2013 17:58:51 GMT https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517172#M193075 2013-09-12T17:58:51Z Re: Compare County to State Average https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517173#M193076 <HTML><HEAD></HEAD><BODY><P>Your attached screenshot is not helping much in understanding your issue. Could you post a small sample application?</P><P></P><P>If you include all fields the user may perform a 'lower selection' in as shown above, the avg should not change. But maybe I am missing something else.</P></BODY></HTML> Thu, 12 Sep 2013 18:03:16 GMT https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517173#M193076 swuehl 2013-09-12T18:03:16Z Re: Compare County to State Average https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517174#M193077 <HTML><HEAD></HEAD><BODY><P>Thanks for your help swuehl.&nbsp; I just added the State Average to a table in the load script.&nbsp; Took care of all my issues.</P><P></P><P>Thanks for your help!</P></BODY></HTML> Mon, 23 Sep 2013 17:05:15 GMT https://community.qlik.com/t5/QlikView/Compare-County-to-State-Average/m-p/517174#M193077 2013-09-23T17:05:15Z