topic Calculate an expression based on a text within Pivot Table in QlikView

Calculate an expression based on a text within Pivot Table

Thu, 20 Jun 2013 13:07:01 GMT

Hi Guys,

I want to know if the following is possible and if not, why

I have a pivot table with the following dimensions

1) Calendar Year

2) ExpressionOverview.MeasureNumber // A list of 42 numbers

The expression is as follows

1) Only(ExpressionOverview.Expression)

This gives me back the calculation used to populate that measure. If I take the above expression and do the following in a text object

=$(=Only(ExpressionOverview.Expression)) it calculates the value correctly. However, if I use the same expression in the expression tab in a pivot table it returns null for all my expressions.

Why is it not calculating? Is it possible to force this calculation with the above method

Your assistance in this regard is greatly appreciated

Cheers,

Byron

Re: Calculate an expression based on a text within Pivot Table

Thu, 20 Jun 2013 13:10:25 GMT

Oh an important note, I know that the dimension measure number needs to be ignored when calculating. So for the actual expression I included a total qualifier. See below for example of before and after

Before - Count(DISTINCT {<Measure4IndicatorExit={'1'}>}DRNum)....

After - Count(TOTAL <CalendarYear> DISTINCT {<Measure4IndicatorExit={'1'}>}DRNum)....

I am probably doing this all wrong, but thats where you smart folks come in

Thanks,

Byron

Re: Calculate an expression based on a text within Pivot Table

Mon, 24 Jun 2013 13:17:45 GMT

bump

Re: Calculate an expression based on a text within Pivot Table

Thu, 27 Jun 2013 14:29:01 GMT

Absolutely last bump promise