Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
DMG
Contributor III
Contributor III

Column Totals when using count if

Hi,

I'm using the following formula

if(count({<APP_PRIO={'High'},[Death Date]={'NA'}>}[DOMAIN_ID])>0,1,0)

This counts domain id's APP_PRIO is high and Death Date is NA, placing 1 in the cell if the value is >0 and 0 otherwise.

This is in a measure, but the total columns for the measure dont add the values of 1 or 0, i assume maybe they are being treated as text values rather than numbers, is there a way to fix this ?

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

In the properties panel for the Chart measure, look for the "Totals function" option and choice sum from the drop-down.

GaryGiles_0-1621941919996.png

 

View solution in original post

1 Reply
GaryGiles
Specialist
Specialist

In the properties panel for the Chart measure, look for the "Totals function" option and choice sum from the drop-down.

GaryGiles_0-1621941919996.png