I have a requirement from a customer in which we would like a table to be unaffected by any selection (basically going against Qlikview methodology!). The trouble I am having is that I can't seem to implement set analysis into my aggr function. I have created a simple(ish) example:
Unit
A
B
C
D
Total
20
30
40
50
Compliant
10
8
12
10
Not Compliant
10
22
28
40
We have units A,B,C,D and the corresponding total, number of complaint systems and number of not compliant systems within a unit. These calcs are created using aggr functions involving counting the number of compliant systems within a unit as follows:
=sum({$< Unit = >} aggr(if(Status = 'LtO Compliant',1,0),System))
Howvever if I now select, for example unit A, all the figures for the rest of the table return 0. Is there any way in which this can be overcome?
I don't really use Aggr. My understanding was that you usually put an aggregation function within the Aggr function but you don't have one, just a 1 / 0 calculation.
But I'd suggest trying also putting the set extension {1<Unit = >} within the aggr function.
sum({1< Unit = >} aggr({1< Unit = >} if(Status = 'LtO Compliant',1,0),System))
May have to try some other placements, eg. within the If statement.
