Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
coloful_architect
Creator II
Creator II

if statement with master measure

Hi guys,

I am trying to simplify my formula and made a master measure to replace this big chunk of division

coloful_architect_0-1626897957224.png

so now it is like this

coloful_architect_1-1626898297149.png

however, it ended up with error message

coloful_architect_2-1626898324480.png

so when it is a pure formula , it is good. but when I replace with  master measure , it does not work.

any idea how I can fix it?

 

3 Replies
Vivek12
Contributor II
Contributor II

Did you get any solution to this?
I am also facing the same issue

Happy_Mask_Salesman
Partner - Contributor III
Partner - Contributor III

@Vivek12 

Would you mind to post the formula of the master measure in order to check and detect syntax errors that might not be displayed?

 

Regards.

 

Aditya_Chitale
Specialist
Specialist

Make sure you are mentioning master measure name correctly in your if Statement.

Regards,

Aditya