# 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 \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor III

## add 3 columns in one measure

Hello experts,

I would like count three columns all together to be in one measure. Is it possible to do that?

Regards,

Zety.

16 Replies
Contributor III
Author

It worksssss! Thank you soooo muchhhh! :))))))) Appreciate it a lot 🙂

Partner - Specialist III

Appreciate if you can accept the above as solution.

Thanks and regards,

Arthur Fong

Contributor III
Author

sorryy, but the value does not accurate.....

because the condition is to check if it is accident or not. The expression that you gave only applies at Immediate_cause_1. while the Immediate_cause_2 and Immediate_cause_3 does not follow the condition 😞

Partner - Specialist III

You would need to provide more info so that we can help:

What is the condition for Immediate_cause_2?

What is the condition for Immediate_cause_3?

Partner - Specialist III

If the conditions are the same, maybe try this:

Count({\$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}[IIR_INCIDENTMAIN_1.IMMEDIATE_CAUSES_1])+

Count({\$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_2)+

Count({\$<[IIR_INCIDENTMAIN_1.INCIDENT_TYPE]={'Accident'}>}Immediate_Cause_3)

Contributor III
Author

Yes, the condition is the same. But, seems like it counts different value because of the dimension.

What should i put in the dimension? Do i need to just input Immediate cause 1 or include everything (Immediate cause 2 + Immediate cause 3) all together?

Partner - Specialist III

It depends on your data model and what your requirement looks like.