topic How to display Days Remaining in Current Month? in QlikView

How to display Days Remaining in Current Month?

jlakehivewyre — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik Community,

This group has been very helpful, and once again, I have some questions. This time, I want to know how to write an expression/formula to show how many days remain in current month.

For example, I can dynamically show "Today" as an expression =Date(Today()), but how can I get it to also show me number of remaining days? Including today.

The answer I'd expect the expression to return would be 10; and when I would look tomorrow, it would dynamically update to 9, and so on.

Thanks in advance.

Re: How to display Days Remaining in Current Month?

vishsaggi — Tue, 22 May 2018 19:41:35 GMT

Try this?

= Ceil(Interval(MonthEnd(Today()) - Today(), 'd'))

Re: How to display Days Remaining in Current Month?

giovanneb — Tue, 22 May 2018 19:53:30 GMT

Hello I created a variable with the function but the idea would be this,

LET vData = Ceil(MonthEnd(Today()) - Today())-1;

Best Regards

Re: How to display Days Remaining in Current Month?

jlakehivewyre — Tue, 22 May 2018 20:18:52 GMT

Thank you, this works like a charm, and outputs the correct days remaining. I may end up creating a variable from it, so I can use it in a few different ways, but this is very helpful.