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.

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
nurulizzaty
Contributor III
Contributor III
Author

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Appreciate if you can accept the above as solution.

Thanks and regards,

Arthur Fong

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

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

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

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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

Do provide more info on your requirements.