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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Haddadi
Contributor
Contributor

Optimizations

Good day,

I hope you are doing well.

Please advise me on how can I optimize the three below codes?

First:

It's a dimension

If(
aggr(
rank(AuditChecklist_ChecklistTypeDateRank,4,2)
,AuditChecklist_Protocol
, AuditChecklist_ChecklistTypeDateRanking)<7

,aggr(
rank(AuditChecklist_ChecklistTypeDateRank,4,2)
,AuditChecklist_Protocol
, AuditChecklist_ChecklistTypeDateRanking)
)

Second

It's a measure:

if(maxstring([AuditChecklist_Checklist.Compliant])=1,'Y'
,if(maxstring([AuditChecklist_Checklist.NonCompliant])=1 and maxstring(AuditChecklist_HasComment) = 1,'N'
,if(maxstring([AuditChecklist_Checklist.NonCompliant])=1 and maxstring(AuditChecklist_HasComment) = 0,'N*'
,if(maxstring([AuditChecklist_Checklist.NotAnswered])=1,'NA'
))))

 

Third

It's a dimension

=if(QuestionID=[SsrmStandardsChecklists_Checklist.QuestionID] ,[SsrmStandardsChecklists_Checklist.Question],
If(isnull(QuestionID),
'-', Null() 
))

 

Labels (1)
2 Replies
vinieme12
Champion III
Champion III

You can optimise second and third calculated dimensions by creating them in your load script 

First one is basically filtering top 6 , nothing to do there

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Karim_Haddadi
Contributor
Contributor
Author

Thanks