Straight Table

[#1]

Hi All,

For some weird reason the once I click on the Middle option on the Categories list box there are values labeled as Small showing up in the categories section in the straight table.

Please help....

Thanks in Advance,

[swuehl]

You also need to use the aggr() function in your list box:

=Aggr(Only({1}If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 500, 'Small',

  If(RangeAvg(SepRound, OctRound, NovRound, DecRound, JanRound, FebRound) <= 12000, 'Middle', 'Large'))),[Customer Internal ID])

[#3]

Thanks Stefan, the total for average column isn't showing up. I don't know why please provide insights.

[swuehl]

That's because the expression

money(RangeAvg(SepRound,OctRound,NovRound,DecRound,JanRound,FebRound))

doesn't use an aggregation function for aggregating across the dimensional lines.

How do you want to aggregate these values? Like this?

money(RangeAvg(Sum(SepRound),Sum(OctRound),Sum(NovRound),Sum(DecRound),Sum(JanRound),Sum(FebRound)))

[#5]

You're awesome Stefan, thanks. One last request are these charts possible in Qlik my end user has done it in Excel and wants me to imitate it in Qlik.

[swuehl · Accepted solution]

Looks like you can use a pivot table grid with some background / text coloring, like shown e.g. here

Pivot Table Grids | Qlikview Cookbook

[#7]

Thanks for all your help!!!!!!