topic Re: Max Quarter Spend in QlikView

Max Quarter Spend

alis2063 — Wed, 01 Nov 2017 19:21:59 GMT

I am trying to calculate the Max Quarter Amount based on below calculation but it is throwing Error,

NUM(sum({$<NCRQuarter={$(vMaxQuarter)}>} Actual_Amount), '###')

Where

vMaxQuarter='Q'&Max(ceil(month(NCRIdentificationDate)/3))

NCRQuarter='Q'&CEIL( MONTH(NCRIdentificationDate) / 3)

Please help.

sunny_talwar — Wed, 01 Nov 2017 19:23:21 GMT

May be try this

NUM(sum({$<NCRQuarter={'$(=vMaxQuarter)'}>} Actual_Amount), '###')

alis2063 — Wed, 01 Nov 2017 19:31:08 GMT

Hi Sunny,

Thanks for reply.

But it is still showing error as 'error in set modifier ad hoc element list'

sunny_talwar — Wed, 01 Nov 2017 19:38:59 GMT

Try with double quotes

NUM(sum({$<NCRQuarter={"$(=vMaxQuarter)"}>} Actual_Amount), '###')

alis2063 — Wed, 01 Nov 2017 19:46:48 GMT

THANKS for help dear..