topic Quarters wrong in QlikView

Quarters wrong

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

Hi all,

In my script am using this expression to dispaly quarters information 'Q' & Ceil(Month([Sales_Date]/3)) as Quarters

but coming to report getting the data like this in Quarters filed

Q10

Q11

Q12

Can you please give me the solution for this..

Re: Quarters wrong

oknotsen — Thu, 07 Jul 2016 08:55:25 GMT

You are dividing the Date by 3, not the Month.

Move the /3 to the right, past 1 bracket, and that should solve your problem.

'Q' & Ceil(Month([Sales_Date])/3)

Re: Quarters wrong

sonysree88 — Thu, 07 Jul 2016 09:04:16 GMT

Here 'Q' & Ceil(Month(Date)/3) as Quarters ----> its working fine but again am getting the data like this :

now 4 quarters are coming correctly but Extra Q also have in data,Why its coming didnt understand

Re: Quarters wrong

oknotsen — Thu, 07 Jul 2016 09:31:08 GMT

I assume you have NULL values in the Date field. In other words: The Date field is empty on some rows.

Re: Quarters wrong

Chanty4u — Thu, 07 Jul 2016 09:35:35 GMT

create something lik dis

Quarters_Map:

MAPPING LOAD

rowno() as Month,

'Q' & Ceil(rowno()/3) as Quarter

Autogenerate(12);

Re: Quarters wrong

sonysree88 — Thu, 07 Jul 2016 10:25:21 GMT

Yes Date filed is having null values ..

Now its working fine Thanks for the answers

Re: Quarters wrong

sunny_talwar — Thu, 07 Jul 2016 10:30:43 GMT

It might also be possible that some of your date fields are not read as date and when you find it's Month(), it ends up giving you null. Look here for how to get the dates right in QlikView

Get the Dates Right

Why don’t my dates work?

Re: Quarters wrong

oknotsen — Thu, 07 Jul 2016 10:36:39 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .