Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
derekledbetter
Contributor III
Contributor III

Table with 2 Dimension - needing one

To whom it may concern:

I followed the previous thread with one dimension and it did not work for me.  Therefore, I'm writing for assistance in this formula.

Any assistance is appreciated in advance.

Thanks,

Derek

1 Solution

Accepted Solutions
sunny_talwar

May be try one of these

Count(CSN)/Aggr(NODISTINCT Count(CSN), DepartmentName)

or

Count(CSN)/Count(TOTAL <DepartmentName> CSN)

View solution in original post

2 Replies
sunny_talwar

May be try one of these

Count(CSN)/Aggr(NODISTINCT Count(CSN), DepartmentName)

or

Count(CSN)/Count(TOTAL <DepartmentName> CSN)

View solution in original post

derekledbetter
Contributor III
Contributor III
Author

Both work perfectly.

I'm most grateful for the time and effort spent.

This is Solved.

Thanks,

Derek