SINE function

Anonymous — Thu, 10 Sep 2015 18:53:38 GMT

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

Re: SINE function

jolivares — Thu, 10 Sep 2015 19:17:49 GMT

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 — Thu, 10 Sep 2015 19:17:53 GMT

QlikView has sin function. have you tried it already?

Anonymous — Mon, 14 Sep 2015 19:01:26 GMT

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(2PI()/5)/2)/(1Sin(2*PI()/5)/2))/5- calculate as %
Timeliness	1	6	3	5	3	0	-49	51%		<< [Category Score]={"Timeliness"}{<[Category Score]={"Completeness"}>}Sin(2PI()/5)/2)/(1Sin(2*PI()/5)/2))/5- calculate as %
Completeness	1	0	1	6	1	0	-13	87%		<< [Category Score]={"Completeness"}{<[Category Score]={"Accuracy"}>}Sin(2PI()/5)/2)/(1Sin(2*PI()/5)/2))/5- calculate as %
Accuracy	1	0	3	1	1	0	-19	81%		<< [Category Score]={"Accuracy"}{<[Category Score]={"Functionality"}>}Sin(2PI()/5)/2)/(1Sin(2*PI()/5)/2))/5- calculate as %
Functionality	1	1	1	3	2	0	-18	82%		<< [Category Score]={"Functionality"}{<[Category Score]={"Availability"}>}Sin(2PI()/5)/2)/(1Sin(2*PI()/5)/2))/5- calculate as %