Quarters wrong

[sonysree88]

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

Q

Q1

Q2

.

.

.

Q8

Q9

Q10

Q11

Q12

Can you please give me the solution for this..

[oknotsen]

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)

[sonysree88]

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

Q

Q1

Q2

Q3

Q4

[oknotsen · Accepted solution]

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

[Chanty4u]

create something  lik dis

Quarters_Map:

MAPPING LOAD

     rowno() as Month,

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

Autogenerate(12);

[sonysree88]

Yes Date filed is having null values ..

Now its working fine Thanks for the answers

[sunny_talwar]

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?

[oknotsen]

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 .