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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

Master measure expression is not working

Hi,

 

I have to write a master measure expression like below:-

( Contract End Date - (Period End Date + 1 Day) ) / 30.41667 

but it's just giving me blank value, and if I use sum then I am getting some number.

sum(Contract End Date - (Period End Date + 1 Day) ) / 30.41667 

User wants expression like ( Contract End Date - (Period End Date + 1 Day) ) / 30.41667 

without sum, so If someone wants to make AVG they can sum and make count on their own:

Is it possible?

1 Reply
choubeji
Contributor II
Contributor II

When not to average function instead