Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The problem is that that I the list of possible values is unknown
בתאריך יום א׳, 17 בדצמ׳ 2017 ב-16:08 מאת surendra j <
qcwebmaster@qlikview.com>:
Where are you trying this? IS that from Pivot or Text box??
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.
What is your expression for Grades? Use like
= Avg(Aggr(Sum(yourexpression), Dimension))
Thanks Surenda, that is what I was looking for