Aggr Count doesn't work

Kunkulis — Fri, 25 Jun 2021 13:08:08 GMT

Hello,

I am trying to check if there is only empty values in a straight table or there is at least 1 value

Example:

ID	Viewer
1
1	Person1
1
2
2
2

Empty cell is '' not null

So with the example data above, when I select to add a Viewer column to table, I would expect to see:

ID	Viewer
1	Person1
2

for the viewer table I use this calculated dimenstion:

=if(aggr(count(distinct [Viewer]),[ID])=1,[Viewer], if([Viewer]='',Null(),[Viewer]))

For my test the formula above works perfectly as it should, but then I add it to my dynamic table, where other things are checked as well, it doesn't work at all:

=if(WildMatch(GetFieldSelections(DetailDim_, ','),'*Approver*Editor*Viewer*'), if([Approver]='' and [Editor]='' and [Viewer]='',Null(),[Viewer]), if(WildMatch(GetFieldSelections(DetailDim_, ','),'*Editor*Viewer*'), if([Editor]='' and [Viewer]='',Null(),[Viewer]), if(WildMatch(GetFieldSelections(DetailDim_, ','),'*Approver*Viewer*'), if([Approver]='' and [Viewer]='',Null(),[Viewer]), if(aggr(count(distinct [Viewer]),[ID])=1,[Viewer], if([Viewer]='',Null(),[Viewer])))))

So far what I have noticed its the WildMatch and/or GetFieldSelections that is messing it up. Once I add the Aggr part under true or false, it doesn't show the empty cases for the IDs.

Additional info for the table we have.
In Straight Table we have checked 'Suppress when Value is null' and Enable Conditional:

=substringcount('|'&GetFieldSelections(DetailDim_, '|', 100)&'|','Viewer')

Re: Aggr Count doesn't work

Kunkulis — Mon, 28 Jun 2021 12:00:42 GMT

Not sure why it didn't work at the first place, but rather then using GetFieldSelections I opted for GetCurrentSelections.

topic Re: Aggr Count doesn't work in QlikView

Aggr Count doesn't work

Re: Aggr Count doesn't work