topic Re: Charts with aggr function in QlikView https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148406#M907372 <HTML><HEAD></HEAD><BODY><P>May be like attached?</P><P>You can concat the City &amp; ID in the calculated dimension and put the expression 'Median(Value')</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128446_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 20 Jun 2016 02:29:58 GMT settu_periasamy 2016-06-20T02:29:58Z Charts with aggr function https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148403#M907369 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have the simple attached app, I want to be able to create bar chart or pie chart to see the median of values per category for each ID in each city. Can someone please help? Should use two aggrs but not sure how I can do it and display in charts</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148403#M907369 2020-11-25T16:16:04Z Re: Charts with aggr function https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148404#M907370 <HTML><HEAD></HEAD><BODY><P>I also want to be able to do filtering by ID after creating the charts...</P></BODY></HTML> Mon, 20 Jun 2016 00:01:21 GMT https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148404#M907370 2016-06-20T00:01:21Z Re: Charts with aggr function https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148405#M907371 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Are you able to provide a screenshot of what the end result should look like.</P></BODY></HTML> Mon, 20 Jun 2016 01:35:40 GMT https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148405#M907371 2016-06-20T01:35:40Z Re: Charts with aggr function https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148406#M907372 <HTML><HEAD></HEAD><BODY><P>May be like attached?</P><P>You can concat the City &amp; ID in the calculated dimension and put the expression 'Median(Value')</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/128446_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 20 Jun 2016 02:29:58 GMT https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148406#M907372 settu_periasamy 2016-06-20T02:29:58Z Re: Charts with aggr function https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148407#M907373 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes we need to use two dimension. Use expression like this,</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">aggr</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">median</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Value</SPAN><SPAN style="font-size: 8pt;">),</SPAN><SPAN style="color: #800000; font-size: 8pt;">ID</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">City</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P></BODY></HTML> Mon, 20 Jun 2016 07:30:03 GMT https://community.qlik.com/t5/QlikView/Charts-with-aggr-function/m-p/1148407#M907373 muthukumar77 2016-06-20T07:30:03Z