topic Re: Multiplication of single values in QlikView https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421370#M798679 <HTML><HEAD></HEAD><BODY><P>create a date field and use avg as expression</P><P>regards</P></BODY></HTML> Mon, 18 Dec 2017 12:17:06 GMT martinpohl 2017-12-18T12:17:06Z Multiplication of single values https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421369#M798678 <HTML><HEAD></HEAD><BODY><P>Hello community,</P><P></P><P>i need one more time your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P></P><P>i have a Diagramm (1.Dimension = month_day_hour; 2. Dimension = Process; Expresion = Output/Input (%), so i get following result:</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187320_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>But i Need (want) to multiplicate the single Values for all processes over one month_day_hour, to get the trend...</P><P></P><P>Is it posible with Qlik View?</P><P></P><P>Thanks in advance!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421369#M798678 Anonymous 2020-11-25T16:16:04Z Re: Multiplication of single values https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421370#M798679 <HTML><HEAD></HEAD><BODY><P>create a date field and use avg as expression</P><P>regards</P></BODY></HTML> Mon, 18 Dec 2017 12:17:06 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421370#M798679 martinpohl 2017-12-18T12:17:06Z Re: Multiplication of single values https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421371#M798680 <HTML><HEAD></HEAD><BODY><P>Sorry, but i don't Need the avg, i want to multiplicate the single values grouped by each column of the Dimension...</P></BODY></HTML> Tue, 19 Dec 2017 06:31:16 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421371#M798680 Anonymous 2017-12-19T06:31:16Z Re: Multiplication of single values https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421372#M798681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use Aggr function for this: </P><P></P><P>Sum(Values)* Aggr(MultiplierValue,Dim2,Dim1)</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Tue, 19 Dec 2017 06:34:15 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421372#M798681 sushil353 2017-12-19T06:34:15Z Re: Multiplication of single values https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421373#M798682 <HTML><HEAD></HEAD><BODY><P>Hello Sushil,</P><P></P><P>I've tried it, but it doesn't work.</P><P>1.) What is "MultiplierValue"? Is this a function?<IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187466_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>2.) Dim2, Dim1 are the Dimensions, right? What is if my Dim1 is a dynamic Dimension?</P><P></P><P>Tahnak in advance.</P><P>Alin</P></BODY></HTML> Tue, 19 Dec 2017 07:03:36 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-single-values/m-p/1421373#M798682 Anonymous 2017-12-19T07:03:36Z