Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bijoylalu
Contributor

Fetching a SUM of selected items on match specified item

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.

3 Replies

Re: Fetching a SUM of selected items on match specified item

Try a set analysis expression: sum({<[FINANCIAL-ITEM]={'Assets'}>}rangesum(QTR1,QTR2,QTR3,QTR4)).

The {<[FINANCIAL-ITEM]={'Assets'}>} bit restricts the calculation to the records where FINANCIAL-ITEM is Assets.


talk is cheap, supply exceeds demand
bijoylalu
Contributor

Re: Fetching a SUM of selected items on match specified item

It worked. Thank you @Gysbert

bijoylalu
Contributor

Re: Fetching a SUM of selected items on match specified item

It worked !