Move calculated dimension to expression?

[#1]

Hi community,

I want to move the calculated part or leafname=FieldA, of the calculated dimension of: if(leafname=FieldA,ProfitDim) to the expression

I've tried just adding in leafname=FieldA, as a line of the expression and changing the dimension to ProfitDim but its not working.  Any ideas?

[#2]

Hi,

Can you provide a qlikview file as an example?

Regards,

http://quickdevtips.blogspot.com/

[#3]

Here you go,  i show how i originally used a calculated dimension, how i used a work-around loading the dimension in the script, and what I tried for getting the calculation into the expression. 

Regards and thanks so much for any help!

Brandon

[#4]

Hi,

I am not sure if I understood your problem but may be you mean changing the expression like below:

  -1*sum({ $<  balcode3={'ACTUAL'},

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

LinkMonth=CurrentDocumentMonth3,

[code3]={'DEPTSTMTSACT'}

>} if(leafname=el3,Tot3))

So, I just moved the IF stament from Dimension (dimension is now GL_Account_Number_Name_Profit_Loss3) to Expression (right aroung Tot3).

regards,

http://quickdevtips.blogspot.com/