Qlikview - sum in expression

[Anonymous]

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]

dimension > State

Expression > Sum(Amount)

Regards,

[its_anandrjs]

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

=GetSelectedCount(States) > 0

Dim :- State

Expre:- =sum(Amount)

[its_anandrjs]

Or May this expression also

Dim :- State

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

[dinuwanbr]

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]

May be This!!

Did u tried with

aggr(Sum(Amount),Item,Location)

--Surendra