If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I'm using the following formula
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 ?
In the properties panel for the Chart measure, look for the "Totals function" option and choice sum from the drop-down.
View solution in original post