topic Re: Straight Table in QlikView

Straight Table

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Straight Table

swuehl — Fri, 01 Apr 2016 12:43:42 GMT

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])

Re: Straight Table

Fri, 01 Apr 2016 12:47:05 GMT

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

Re: Straight Table

swuehl — Fri, 01 Apr 2016 12:53:14 GMT

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)))

Re: Straight Table

Fri, 01 Apr 2016 13:24:28 GMT

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.

Re: Straight Table

swuehl — Fri, 01 Apr 2016 13:49:15 GMT

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

Pivot Table Grids | Qlikview Cookbook

Re: Straight Table

Fri, 01 Apr 2016 15:16:54 GMT

Thanks for all your help!!!!!!