Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

calcul rate using the last day

Hello,

I have to calcul rate and i use this in the script :

(sum(value)/ day((Date)) ) as Rate

Now i need to replace day(date) by the last day of the month

Thanks for help

Regards

1 Solution

Accepted Solutions
rahulpawarb
Valued Contributor III

Re: calcul rate using the last day

May be this:

Sum(value)/Day(MonthEnd(Date)) AS Rate

Regards!

Rahul

1 Reply
rahulpawarb
Valued Contributor III

Re: calcul rate using the last day

May be this:

Sum(value)/Day(MonthEnd(Date)) AS Rate

Regards!

Rahul

Community Browser