Variable

[Upali_Wijearatne]

Hi Friends

I have created following variable in QV document

vSpq=sum({<PRD_FLG={'I'}>}CP_QTY)

I want to use above variable in expression of my pivot table which is as follows

SUM({<PERIOD={$(=Max(PERIODID))}>}$(vSpq))

How no results are shown 

Pls help me to identify the error and let me have correct expression please

[PradeepK]

You cannot use nested aggregation like this.. i.e. Sum(Sum()).. look into Aggr() function to use nested aggregation.

In your case try

SUM({<{<PRD_FLG={'I'},PERIOD={$(=Max(PERIODID))}>}CP_QTY)

[Upali_Wijearatne]

Thanks 

Could you suggest me to write the expression with a variable

[PradeepK]

If you want more control / dynamic variables; look into parameterised variables!

Example for reference -

vVariable = SUM( {<PRD_FLG={'I'},PERIOD={$(=Max(PERIODID))}>} $1 )

Call parameterised variables

$(vVariable(CP_QTY))