Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ops_team
Contributor II
Contributor II

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

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

Labels (3)
2 Replies
Brett_Bleess
Employee
Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Surya
Creator II
Creator II

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