topic Re: issue with quarter function,need help please! in QlikView

issue with quarter function,need help please!

Fri, 15 Aug 2014 06:34:11 GMT

hi all,

I have given the below expression to obtain quarter field and from date field called Month.but I get the below result as

'Quarter' & ceil(month(Month)/3) as Quarter ,

quarter

Quarter

Quarter1

Quarter2

Quarter3

Quarter4

Here I do not want the value Quarter how do I modify this to get the below result

quarter

Quarter1

Quarter2

Quarter3

Quarter4

please can someone help me out to resolve this??

sahana

Re: issue with quarter function,need help please!

ecolomer — Fri, 15 Aug 2014 06:40:18 GMT

Hi,

Check list values of Month, I thiks there are an "blank" or similar

For that you can create a table with:

Month Q

where Month is your values and Q is ceil(month(Month)/3)

Re: issue with quarter function,need help please!

Fri, 15 Aug 2014 06:44:41 GMT

Hi Enrique,

I checked,there are no blanks,null etc in the list of month in the excel sheet.How do I proceed,please guide.

Sahana

Re: issue with quarter function,need help please!

ecolomer — Fri, 15 Aug 2014 06:51:16 GMT

I think you should have rows in your excel worthless.

do the following, stand in the next row to the last valid value and delete all lines to the end

Re: issue with quarter function,need help please!

Fri, 15 Aug 2014 07:20:22 GMT

hi,

its actually taking the data directly from database.Is there a way to restrict the blanks in the script level while using this function??

sahana

Re: issue with quarter function,need help please!

jagan — Fri, 15 Aug 2014 07:30:07 GMT

Hi,

I think for some records the Months are missing that is why you are getting just Quarter, if you want to remove those then try like this

LOAD

If(Len(Trim(Month)) > 0, 'Quarter' & ceil(month(Month)/3)) as Quarter

FROM DataSource;

The above script assigns null to Quarter which is having no month value.

Hope this helps you.

Regards,

Jagan.

Re: issue with quarter function,need help please!

ecolomer — Fri, 15 Aug 2014 07:32:46 GMT

if(Month>0, 'Quarter' & ceil(month(Month)/3, Null()) as Quarter

Re: issue with quarter function,need help please!

Fri, 15 Aug 2014 07:34:54 GMT

thanku all I learnt something new.

Re: issue with quarter function,need help please!

jagan — Fri, 15 Aug 2014 08:12:17 GMT

Hi,

Please close this thread.

Regards,

jagan.