SINE function

[Anonymous]

I have a formula in Excel that uses the SIN(Sine) function and I am looking to do the same in QlikView.

Here is the Excel Formula- =((R7*R8*SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5

In QV,
R7=[Category Score]={'Availability'}

R8=[Category Score]={'Timeliness'}

Any suggestions?

Thanks!

Dan

[jolivares]

Assuming that you already have the value of R7 and R8, like Sum(R7), make the same formula in QV

Result=((Sum({<Category Score={"Availability"}*Sum({<Category Score={"Timeliness"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5

It works...

[sudeepkm]

QlikView has sin function. have you tried it already?

[Anonymous]

I am getting an error with the above expression.

Error in set modifier element function name:

I am creating the CATEGORY SCORE via expressions, so I think that may be why I am getting the error.

Here is what I am trying to do.

SLA CATEGORY(values Availability-Timeliness-Completeness-Accuracy-Functionality) as a Dimension.

SLA Impact Expressions:

    Critical: =count(DISTINCT {<[SLA Impact]={"Critical"}>}ID)

    High: =count(DISTINCT {<[SLA Impact]={"High"}>}ID)

    Medium: =count(DISTINCT {<[SLA Impact]={"Medium"}>}ID)

Calculate Points Deducted{Multiply & Add SLA Count by} =(Critical *(-10)) + (High *(-5)) + (Medium *(-3))

Calculate Category Score: =(1) + ([Points Deducted]/(100))

SLA Category	Critical	High	Medium	Low	No Impact	Repeats	Points Deducted	Category Score	OOTC Score Calculation	Expression needed to calculate OOTC Score Calculation
Availability	2	2	0	2	3	0	-30	70%		<< [Category Score]={"Availability"}*{<[Category Score]={"Timeliness"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5- calculate as %
Timeliness	1	6	3	5	3	0	-49	51%		<< [Category Score]={"Timeliness"}*{<[Category Score]={"Completeness"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5- calculate as %
Completeness	1	0	1	6	1	0	-13	87%		<< [Category Score]={"Completeness"}*{<[Category Score]={"Accuracy"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5- calculate as %
Accuracy	1	0	3	1	1	0	-19	81%		<< [Category Score]={"Accuracy"}*{<[Category Score]={"Functionality"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5- calculate as %
Functionality	1	1	1	3	2	0	-18	82%		<< [Category Score]={"Functionality"}*{<[Category Score]={"Availability"}>}*Sin(2*PI()/5)/2)/(1*Sin(2*PI()/5)/2))/5- calculate as %