topic Re: My rounding on quarter expression does'nt work in QlikView

My rounding on quarter expression does'nt work

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

Hi,

This

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3)))/3 &'-' & year(addmonths(today(),-3)) &' -

looked like this before October 2016

HEADLINES FOR Q2 - 2016 -

If now looks like

HEADLINES FOR Q2.33333333333333333 - 2016 -

What's gone wrong after an extra month was added?

Regards

LAK

sunny_talwar — Tue, 04 Oct 2016 09:49:34 GMT

May be try this:

='HEADLINES FOR ' & 'Q' & Ceil(Month(AddMonths(Today(), -3))/3) &'-' & year(addmonths(today(),-3)) &' -

Anonymous — Tue, 04 Oct 2016 09:51:52 GMT

Ok, that works, what did you change and will the rounding stay the same next quarter? Q4 - 2016?

Anonymous — Tue, 04 Oct 2016 09:53:19 GMT

Does the 'T' in Sunny T, stand for Turbo as you are so fast with your answers.

I've got a unanswered question from around 10 days ago, have you had a look?

sunny_talwar — Tue, 04 Oct 2016 09:54:35 GMT

Just changed the placement of one of the closing parenthesis

From

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3)))/3 &'-' & year(addmonths(today(),-3)) &' -

='HEADLINES FOR ' & 'Q' & ceil(month(AddMonths(today(),-3))/3) &'-' & year(addmonths(today(),-3)) &' -

sunny_talwar — Tue, 04 Oct 2016 09:55:01 GMT

T is for my last name Talwar

Anonymous — Tue, 04 Oct 2016 09:55:48 GMT

yeah saw that.

Anonymous — Tue, 04 Oct 2016 09:56:09 GMT

Sharp like a sword.

sunny_talwar — Tue, 04 Oct 2016 09:58:15 GMT

Yes so the difference was that previously you were ceill and then dividing. and now you are dividing and the ceiling.