topic Include calculated dimension in expression in QlikView

Include calculated dimension in expression

Tue, 05 Jun 2012 15:53:49 GMT

Hi Community,

I have a calcuated dimension I would like to have in the expression of a pivot table(for user functionality reasons.)

the calcluated dimension is if(leafhdrtxt=[Division Abbreviation],[Division Abbreviation])

Any ideas?

Nicole-Smith — Tue, 05 Jun 2012 16:07:31 GMT

only({<leafhdrtxt=[Division Abbreviation]>} [Division Abbreviation])

Tue, 05 Jun 2012 16:13:44 GMT

Let me rephrase that. How would I tie that in with the current expression of:

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

LinkYear= {$(=$(vCurrentFiscalYear))},

LinkMonth=CurrentDocumentMonth3,

={'DPCOMP'}

>}PeriodTotal/1000)

Nicole-Smith — Wed, 06 Jun 2012 12:19:19 GMT

I'm not sure what you're trying to accomplish. How are you trying to tie it in? What is the calculation that you're trying to do?

SunilChauhan — Wed, 06 Jun 2012 13:18:19 GMT

use in express same code

if(leafhdrtxt=[Division Abbreviation],[Division Abbreviation])

hope this help