topic Re: min max avg in QlikView https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117410#M368738 <HTML><HEAD></HEAD><BODY><P>I am not entirely sure, but may be using RangeAvg, RangeMin</P></BODY></HTML> Fri, 20 May 2016 23:14:36 GMT sunny_talwar 2016-05-20T23:14:36Z min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117409#M368737 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P>please let me know if I can get min or avg or mode of seven days data tier in different cells. see picture for clarity.</P><P></P><P>Thanks</P><P>Farhan</P></BODY></HTML> Fri, 20 May 2016 21:58:52 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117409#M368737 engr_farhanqadr 2016-05-20T21:58:52Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117410#M368738 <HTML><HEAD></HEAD><BODY><P>I am not entirely sure, but may be using RangeAvg, RangeMin</P></BODY></HTML> Fri, 20 May 2016 23:14:36 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117410#M368738 sunny_talwar 2016-05-20T23:14:36Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117411#M368739 <HTML><HEAD></HEAD><BODY><P>Hi Farhan,</P><P></P><P>Can you post a sample data set to work with?</P></BODY></HTML> Sat, 21 May 2016 02:43:59 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117411#M368739 2016-05-21T02:43:59Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117412#M368740 <HTML><HEAD></HEAD><BODY><P>try something like this</P><P></P><P>Create Pivot Table</P><P></P><P>Dimension:</P><P>SKU</P><P>Tier&amp;' '&amp;Month</P><P></P><P>Expression:</P><P>Your expression</P><P></P><P>After creating pivot table drag the needed dimension horizontally</P></BODY></HTML> Sat, 21 May 2016 04:41:52 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117412#M368740 Kushal_Chawda 2016-05-21T04:41:52Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117413#M368741 <HTML><HEAD></HEAD><BODY><P>I have posted the sample picture. you can see there</P></BODY></HTML> Sat, 21 May 2016 09:04:57 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117413#M368741 engr_farhanqadr 2016-05-21T09:04:57Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117414#M368742 <HTML><HEAD></HEAD><BODY><P>I have done all this I want the average and min from tiers data.</P></BODY></HTML> Sat, 21 May 2016 09:05:57 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117414#M368742 engr_farhanqadr 2016-05-21T09:05:57Z Re: min max avg https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117415#M368743 <HTML><HEAD></HEAD><BODY><P>I did the same but I had to put all column no for rangeavg. any other way out.as whenever new tier is added i need to add to rangeavg formula.</P></BODY></HTML> Sat, 21 May 2016 09:07:43 GMT https://community.qlik.com/t5/QlikView/min-max-avg/m-p/1117415#M368743 engr_farhanqadr 2016-05-21T09:07:43Z