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: 
Not applicable

Calculated Dimension moved to expression

Hi Community,

I have a graph with two calculated dimensions and an expression. How would I change the calculated dimensions to plain dimensions of GL_Account_Number_Name_Balance_Sheet3 and Department_Number_Name3?

Here are the calculated dimensions:

=if(match(QB22,el2),GL_Account_Number_Name_Balance_Sheet3)

=if(match(QB33,el3),Department_Number_Name3)

Here is the expression:

sum({ $< QBbalcode={'DLHOURS'},

LinkYear={$(=Only("CurrentDocumentYear"))},

LinkMonth=CurrentDocumentMonth3,

={'RBIACCT'}

>}full_value)

I've tried a lot of different things but can't get the same totals. Any ideas? The reason I want to move away from calculated dimensions is that when you click on one it selects all the fields included in the calculation.

1 Reply
Not applicable
Author

Bump!