Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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
Contributor

When not to average function instead