Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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