topic Re: Qlikview - sum in expression in QlikView

Qlikview - sum in expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have bar chart with dimension State, and I need to get sum of Amount group by item,location.

I create bar chart, set dimension State, and try to use dimension like

=sum(aggr(Amount,Item,Location))

and only if I select State I get bar chart for selected state. But I want to have all state in bar chart with sum of amount...

now I have only no data to display.

In sql I use

select state, sum(Amount)

from MyTable

group by Item,Location

I need barchart with dimension state and expressions amount gropu by item,location

Any idea?

PrashantSangle — Thu, 28 Sep 2017 08:19:58 GMT

dimension > State

Expression > Sum(Amount)

Regards,

its_anandrjs — Thu, 28 Sep 2017 08:28:29 GMT

In the Layout properties of the bar chart write expression with your State field

=GetSelectedCount(States) > 0

Dim :- State

Expre:- =sum(Amount)

its_anandrjs — Thu, 28 Sep 2017 08:30:37 GMT

Or May this expression also

Dim :- State

Expre:- =sum(aggr(Amount,Item,Location))

dinuwanbr — Thu, 28 Sep 2017 08:31:14 GMT

Hi,

There is a way to do so

Create a Drill Dimension Group and add State, Item and Location to it.

Then write the expression as Sum(Amount) .

If this is not the what you want, could be more specific.

Rgds,

Tharindu

surendraj — Thu, 28 Sep 2017 08:44:16 GMT

May be This!!

Did u tried with

aggr(Sum(Amount),Item,Location)

--Surendra