topic Re: Help with Aggregation in QlikView https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57308#M773089 <HTML><HEAD></HEAD><BODY><P>What if you just use [Avg Price] for vAvgPrice variable</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/202803_Capture.PNG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Fri, 18 May 2018 14:50:03 GMT sunny_talwar 2018-05-18T14:50:03Z Help with Aggregation https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57307#M773088 <HTML><HEAD></HEAD><BODY><P>Hi all, I have the attached QVW, the aggregation did work but ive had to make a change to the a variable that is uses in a number of the expressions and since the change the aggregation has stopped working.</P><P></P><P>The variable that i have changed is vAvgPrice, which is the first variable in the variable overview.</P><P>the variable used to be a division of sales \ qty. which gave an avg price. now the avg price is provided to me via an excel sheet, so i have changed the variable to use this instead.</P><P>the excel sheet (also attached) has an average price by product and customer, so there would be multiple entries for each item as the price by customer differs.</P><P></P><P>Can anyone help me getting the aggregation to work. </P><P></P><P>an example of an item number is 05842 and a customer (which is selected and locked anywway) is Qnivd.</P><P>The annual sales for this should be 1,452,071.61 which works when the item is selected, but when unselected it shows as 1,210,503.69</P><P>(it is the top row).</P><P></P><P>any help would be great. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57307#M773088 hopkinsc 2020-11-25T16:16:04Z Re: Help with Aggregation https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57308#M773089 <HTML><HEAD></HEAD><BODY><P>What if you just use [Avg Price] for vAvgPrice variable</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/202803_Capture.PNG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Fri, 18 May 2018 14:50:03 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57308#M773089 sunny_talwar 2018-05-18T14:50:03Z Re: Help with Aggregation https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57309#M773090 <HTML><HEAD></HEAD><BODY><P>bloody hell! i cant believe it was that easy!!!</P><P>Thanks Sunny!<IMG src="https://community.qlik.com/legacyfs/online/emoticons/silly.png" /></P></BODY></HTML> Fri, 18 May 2018 14:57:35 GMT https://community.qlik.com/t5/QlikView/Help-with-Aggregation/m-p/57309#M773090 hopkinsc 2018-05-18T14:57:35Z