How to use the Count Function that refers to a specific Object

[kfahri342]

Hi All,

Let me start use an example to better explain myself.

I have the following table:

Object Id: O23

Student Name	Attendance
Tom	Y
Steve	blank
Jackie	Y
Steph	Y

I need to have a separate Text Object that Counts the amount of Attendance's specific to this table. Please let me know what the best expression would to solve this.

Many Thanks!

[swuehl]

You can't reference the output of a chart (expression column) from another chart.

But you can create a virtual table with your expression using advanced aggregation and count the 'Y', something like

=Sum( Aggr( If( YourObjectExpresssion = 'Y',1,0), [Student Name])

Replace the italic part with the expression that returns 'Y' or blank for each student.

QlikView Technical Brief - AGGR.docx

[Anil_Babu_Samineni]

Is you are expecting output as Three?