Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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))

Anonymous
Not applicable
Author

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
Author

Try Above function...