topic Re: Aggr Dual as Dimension in QlikView

Aggr Dual as Dimension

cbaqir — Mon, 05 Feb 2018 19:25:40 GMT

I am trying to stratify vBuildResourceCount into buckets using:

=Aggr(
If(count(vBuildResourceCount) = 0, Dual(0, 0),
If(count(vBuildResourceCount) = 1, Dual('1', 1),
If(count(vBuildResourceCount) = 2, Dual('2-3', 2),
If(count(vBuildResourceCount)< 5, Dual('4-5', 4),
If(count(vBuildResourceCount) > 5 Dual('5 or more', 5)))))),
DEFECT_ID)

Clearly Jan 2018 has some in with Build resource count of 1, 2 o3 3 but I only see a bar for 2-3? Help! What's wrong with my Dual statement?

Re: Aggr Dual as Dimension

cbaqir — Mon, 05 Feb 2018 20:53:13 GMT

stalwar1‌

Re: Aggr Dual as Dimension

swuehl — Mon, 05 Feb 2018 21:46:43 GMT

Try to add your YearMonth dimension to the aggr() dimensions.

Re: Aggr Dual as Dimension

cbaqir — Tue, 06 Feb 2018 00:19:20 GMT

How so? This didn't work:

Re: Aggr Dual as Dimension

swuehl — Tue, 06 Feb 2018 08:16:41 GMT

Yes, something like this.

What if you use this as expression in your straight table, to compare with the results of your count expression?