Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

count of results

Hi all,

This is an easy one i'm sure but i cannot get it to work.

basically i have the following expression in a straight table with 'Name' as a dimension which gives the below result..

if(avg({<[Source_File_Name]={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change)>=$(vKPIThreshold),

avg({<Source_File_Name={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change),0)

Capture.JPG

there is a total of 47 rows in the above table.

what i want to do now is get a count of the rows in a text box, so i just want a text box that shows 47.

can anyone help?

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(Aggr(If(Avg({<[Source_File_Name]={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change)>=$(vKPIThreshold),1, 0), Name))

View solution in original post

2 Replies
sunny_talwar

May be this

Sum(Aggr(If(Avg({<[Source_File_Name]={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change)>=$(vKPIThreshold),1, 0), Name))

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Thanks Sunny!