Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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