Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Aggr Dual as Dimension

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?

2-5-2018 12-22-33 PM.jpg

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Aggr Dual as Dimension

Yes, something like this.

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

4 Replies
cbaqirdhds
Contributor II

Re: Aggr Dual as Dimension

MVP
MVP

Re: Aggr Dual as Dimension

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

cbaqirdhds
Contributor II

Re: Aggr Dual as Dimension

How so? This didn't work:

=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, FISCAL_MONTH_YEAR)

MVP
MVP

Re: Aggr Dual as Dimension

Yes, something like this.

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

Community Browser