topic Move calculated dimension to expression? in QlikView

Move calculated dimension to expression?

Thu, 07 Jun 2012 19:42:02 GMT

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?

Move calculated dimension to expression?

Thu, 07 Jun 2012 20:13:45 GMT

Hi,

Can you provide a qlikview file as an example?

Regards,

http://quickdevtips.blogspot.com/

Re: Move calculated dimension to expression?

Thu, 07 Jun 2012 20:34:07 GMT

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

Move calculated dimension to expression?

Thu, 07 Jun 2012 21:20:35 GMT

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/