Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Value not counted but displayed in a aggregation

Hello,

i have a interesting display of value, even in my opinion it should be not showed at all:

I'm using following aggregation to switch a dynamic table with a variable  Zero and One 

=aggr(if($(vTest)='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers)),Date)

Its a dimension in a straight table:

Applicable88_1-1593770295587.png

Its aggregated to the date.autocalendar.date. As you can see my switch is set to 'zero' which is my variable vTest='0'.

So the count should only referring to the serialnumbers with a status2='K'. But why I can also see a number count for these who have Status V, just because they share the same date? 

But when I'm adding sum function it really counts me ONLY the ones which should be filtered correctly:

=sum(aggr(if($(vTest)='0',count({$<Status2={'K'}>}Serialnumbers),count({$<Status2={'V'}>}Serialnumbers)),Date))

Is it intended to aggregate the count like this?

Thanks in advance.

 

 

 

 

0 Replies