Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make complicated calculated dimension included into expression

Here is my calculated dimension:

=if((BLMonth1<=CurrentDocumentMonth3 or BLYear<"CurrentDocumentYear" or BLMonth=0) and BLYear<="CurrentDocumentYear",GL_Account_Number_Name_Balance_Sheet3)

Here is my expression:

sum({ $<  balcode3={'ACTUAL'},

[code3]={'RBIACCT'}

             >}Tot3)

Is there anyway to have my dimension just be GL_Account_Number_Name_Balance_Sheet3 and have the expression contain all the logic for the calculated dimension?


0 Replies