Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mazman65
New Contributor III

Using SIN function with Expressions

I am trying to use the SIN function from Expressions that I am creating.

 

Dimension:
SLA Category
(values Availability-Timeliness-Completeness-Accuracy-Functionality)

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

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

Points Deducted: =(Critical *(-10)) + (High *(-5)) + (Medium *(-3))
Category Score: =Num((1) + ([Points Deducted]/(100)),'#,##0.%')

     

SLA CategoriesCritical

High

MediumLowNoneRepeatsPoints DeductedCategory Score

OOTC

Score Calculation

OOTC Score Calculation Formula
Availability220230-3070%=((Availability Category Score * Timeliness Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5'
Timeliness163530-4951%=((Timeliness Category Score * Completeness Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5'
Completeness101610-1387%=((Completeness Category Score * Accuracy Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5'
Accuracy003120-991%=((Accuracy Category Score * Functinoality Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5/
Functionality111320-1882%=((Functionality Category Score * Availability Category Score *SIN(2*PI()/5)/2)/(1*SIN(2*PI()/5)/2))/5'

I have tried this express, but am getting an error -Error in set modifier element function name:

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

Any help is greatly appreciated!

Dan

3 Replies
admin1
New Contributor III

Re: Using SIN function with Expressions

I have also tried this expression and still am getting the "Error in Expression:"

=((Sum([Category Score]='Availability' *Sum([Category Score]='Timeliness' *sin(2*Pi()/5)/2)/(1*sin(2*Pi()/5)/2))/5))

mazman65
New Contributor III

Re: Using SIN function with Expressions

I have also tried this Expression and still get the "Error in Expression"

=((Sum([Category Score]='Availability' *Sum([Category Score]='Timeliness' *sin(2*Pi()/5)/2)/(1*sin(2*Pi()/5)/2))/5))

Not applicable

Re: Using SIN function with Expressions

Try Above function...

Community Browser