How to all the calculations in the script in qliksense?
Hi every one,
I have different table
TableName: AQWA_ID CATEGORY_ID CATEGORY_NAME CAUSE CONVERTED_TO_ISSUE (1,0 if 1 it is converted into issue if Zero not converted into issues) COPY CREATED_ACTION CREATED_AT CREATED_BY DETECTABILITY FROM_IMPACT FROM_WAIT RISK_ID IMPACT ISSUE_EID LEVEL_SPECIFIC MITIGATION_STRATEGY PROBABILITY QTL RE_OPEN SCORE (Low Score, Median Score, High Score) SERVICE_ID SERVICE_NAME STATUS STATUS_NAME (Values-> Open, Closed, Reopen) SUPPLIER_NAME TRIAL_ID RISK_TYPE (Values--> RISK, ISSUE)
Here i need to calculate how many risk_Ids are assigned to STATUS_NAME wise and SERVICE_NAME, QTL
How many risks are converted into issues CONVERTED_TO_ISSUE ,
Count of risks by CATEGORY_NAME
actually i have all these aclculation in frontend side i am facing performance issues so i need to calculate all these calculation in scripting side please guide e here all Expertise
Very thanks for being helping me..
I need to do all these calculation in scripting side how can i do please guide here