topic Variable in QlikView

Variable

Upali_Wijearatne — Sat, 27 Feb 2021 06:50:36 GMT

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 — Sat, 27 Feb 2021 07:53:17 GMT

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 — Sat, 27 Feb 2021 08:05:47 GMT

Thanks

Could you suggest me to write the expression with a variable

PradeepK — Sat, 27 Feb 2021 08:50:09 GMT

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