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: 
nurulizzaty
Contributor III
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?

Really need your insights.

Thanks in advance.

Regards,

Zety. 

16 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

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

nurulizzaty
Contributor III
Contributor III
Author

Cannot. It returned 0 value 😞

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

You have a sample app?

nurulizzaty
Contributor III
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.... 😞

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Do something like this:

MC.PNG

For your case:

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)

nurulizzaty
Contributor III
Contributor III
Author

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try this:

Count (Immediate_cause_1)+

Count(Immediate_Cause_2)+

Count(Immediate_Cause_3) 

nurulizzaty
Contributor III
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])

Arthur_Fong
Partner - Specialist III
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)