topic Re: Multiply function in QV in QlikView

Multiply function in QV

karin_nevo — Sun, 17 Dec 2017 13:43:33 GMT

Hi.

I am using aggr function to get a grade per specific dimension.

For example:

dImension Grade

A 100%

B 80%

C 70%

D 99%

now, I need to multiply all results to get a final grade (100%*80%*70%*99%=55.44%)

which function in QV can I use to achieve the required result?

thanks,

Karin

surendraj — Sun, 17 Dec 2017 14:07:07 GMT

May be this!!

Sum(If(dImension= 'A', Grade)) * Sum(If(dImension= 'B', Grade)) * Sum(If(dImension= 'C', Grade)) * Sum(If(dImension= 'D', Grade)) * 100 as finalgrade

karin_nevo — Sun, 17 Dec 2017 14:16:31 GMT

The problem is that that I the list of possible values is unknown

בתאריך יום א׳, 17 בדצמ׳ 2017 ב-16:08 מאת surendra j <

qcwebmaster@qlikview.com>:

Anil_Babu_Samineni — Sun, 17 Dec 2017 14:29:16 GMT

Where are you trying this? IS that from Pivot or Text box??

surendraj — Sun, 17 Dec 2017 14:30:44 GMT

If the numbers are all positive (from Alexander Schubert):

exp(sum(log(Grade)))*100 as finalgrade

if we need the value in percentage,it should be multiply with 100.

vishsaggi — Sun, 17 Dec 2017 18:34:19 GMT

What is your expression for Grades? Use like

= Avg(Aggr(Sum(yourexpression), Dimension))

karin_nevo — Mon, 18 Dec 2017 07:57:07 GMT

Thanks Surenda, that is what I was looking for