8 Replies Latest reply: Dec 13, 2012 12:35 PM by Kumar Natarajan RSS

    Expression as set analysis value

      Hello, i have the following expression in a qlikview chart


      Sum({<MES_AÑO={'Oct-11'}>} TOTAL FLG_CRO), where MES_AÑO is the chart dimension,


      and i need to replace the constant 'Oct-11' by the following expression: SubField(MES_AÑO, '-', 1) & '-' & (SubField(MES_AÑO, '-', 2) - 1)


      I tried several options but none worked, any idea?