Multiply function in QV

[karin_nevo]

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]

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]

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]

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

[surendraj]

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]

What is your expression for Grades? Use like

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

[karin_nevo]

Thanks Surenda, that is what I was looking for