3 Replies Latest reply: Jul 20, 2016 5:56 AM by Bijoy B RSS

    Fetching a SUM of selected items on match specified item

    Bijoy B

      Hi,

              I am new with QlikSense. I need to get yearly asset details(SUM) from Quarterly defined data available. Attaching a screenshot of sample datasource

      DataSource-Input.JPG

      I need to create a BarChart with Dimension as 'BANK'. I need to customize my measure in such a way,

              1. Need to consider when FINANCIAL-ITEM = 'Assets'.

              2. Its should be yearly basis [Sum(QTR1) + Sum(QTR2) + Sum(QTR3) + Sum(QTR4)].

              3. I don't want to use any filter Pane.

       

      I tried the below expression to fetch the Measure, but its not working

              match(match([FINANCIAL-ITEM],'Assets','Liabilities'),Sum(QTR1) + Sum(QTR2) + Sum(QTR3) + Sum(QTR4),0)

       

      Can someone suggest me an expression to calculate this measure. Thanks in advance, appreciated.