topic Re: Include calculated dimension in expression in QlikView

Include calculated dimension in expression

Tue, 05 Jun 2012 16:39:57 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])

The expression to tie it into is:

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

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

LinkMonth=CurrentDocumentMonth3,

={'DPCOMP'}

>}PeriodTotal/1000)

Any ideas?

Include calculated dimension in expression

Oleg_Troyansky — Tue, 05 Jun 2012 17:34:02 GMT

Not sure what are you trying to achieve with the calculated dimension, and what do you mean by "tying the expression" to it? Please clarify the desired goal and the question.

Include calculated dimension in expression

Tue, 05 Jun 2012 18:12:27 GMT

I have a pivot table with the inner most dimension as the calculated one above. I would like to have the dimension as just division abbreviation and include the calculated part in the expression for the chart(same as one above.)

Include calculated dimension in expression

Wed, 06 Jun 2012 03:12:58 GMT

I had to use the calculated dimension to get the chart to give the right value

Re: Include calculated dimension in expression

Nicole-Smith — Fri, 08 Jun 2012 13:39:04 GMT

Try this:

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

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

LinkMonth=CurrentDocumentMonth3,

[code]={'DPCOMP'},

leafhdrtxt=[Division Abbreviation]

>}PeriodTotal/1000)