# 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
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
Partner - Specialist III

Try this:

Column(1)+Column(2)+Column(3)

Contributor III
Author

Cannot. It returned 0 value 😞

Partner - Specialist III

You have a sample app?

Contributor III
Author

I don't have it. But i can give you the example.

Eg:

Dimension : Immediate_cause

Measure : Count (Immediate_cause_1) + (Immediate_Cause_2) + (Immediate_Cause_3)

But it gave me 0 value in return.... 😞

Partner - Specialist III

Do something like this:

if Count (Immediate_cause_1) is your first expression, then this will be column(1).

Count(Immediate_Cause_2) should be your second expression, then this will be column(2).

Count(Immediate_Cause_3) should be your third expression, then this will be column(3).

So your last expression will looks like:

column(1)+column(2)+column(3)

Contributor III
Author

but I'm using the word cloud graph...there's no multiple measure to add, can input only one measure...

Partner - Specialist III

Try this:

Count (Immediate_cause_1)+

Count(Immediate_Cause_2)+

Count(Immediate_Cause_3)

Contributor III
Author

it workssss! But how do i add the condition to only count accident only. Because it doesn't allow me to do nested count.

Right now, the calculation for calculating one measure which is Immediate_cause_1 is :

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

Partner - Specialist III

Try this maybe:

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

Count(Immediate_Cause_2)+

Count(Immediate_Cause_3)

Tags
Community Browser