Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Include calculated dimension in expression

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?

4 Replies
MVP
MVP

Include calculated dimension in expression

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.

Not applicable

Include calculated dimension in expression

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.)

Not applicable

Include calculated dimension in expression

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

Re: Include calculated dimension in expression

Try this:

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

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

LinkMonth=CurrentDocumentMonth3,

[code]={'DPCOMP'},

leafhdrtxt=[Division Abbreviation]

             >}PeriodTotal/1000)

Community Browser