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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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