New to QlikView-- Totals creating new entries with empty values

[ops_team]

Dear Sir

I read the following post which you solved for a similar issue I am working on - https://community.qlik.com/t5/QlikView-App-Development/Count-total/td-p/954189.

I have a visual where I want to show the total students in all programs delivered in a semester for every student campus. When I select the course college filter, this total students field should not change. I used the below formula which is same as what was given in the above link and it worked in showing the total student count per program per student campus for each semester. However, it is resulting in empty entries where there is a distinct count of students for a program with no title.

sum({<[Course College]= >}Aggr(Count({<[Course College]= >}DISTINCT Enrolment.EMPLID),[Enr Degree Desc],[Semester Year Name], Location))

Please assist.

Regards

OPS

[Brett_Bleess]

Hey guys, you are very likely going to need to attach an app/QVW on this one to get responses from someone that can actually help, as I suspect they are going to want to see the data model as well.  The best I can offer is the following Design Blog link that might potentially help you figure something out here:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Best I have, sorry.  This will kick things back up, so maybe someone else will have another look and have a different idea etc.

Regards,
Brett

[Surya]

Hello.,

Please check Tabular Viewer .,

if there is no association Between tables on that time also we are getting the same.,

make sure maintain Association between the tables.,

if u maintain all the formal level sent me sample application