topic Re: Quarter Function in QlikView

Quarter Function

ch_riadh — Thu, 04 Dec 2014 08:06:39 GMT

i wrote the quarter function : 'Q' & Ceil (Month(Date)/3) AS Quarter,

But It SHowed me :

I Don't want to see the Q,
i need Only Q1, Q2, Q3 and Q4.

Thank Guys.

MK_QSL — Thu, 04 Dec 2014 08:17:03 GMT

Instead of using FieldName Quarter in List box use expression and use below

=if(Len(Quarter)>1, Quarter)

its_anandrjs — Thu, 04 Dec 2014 08:23:43 GMT

It seems correct can you share app or you can do some change in the load script

Load

If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter

From Source;

Regards

Anand

ch_riadh — Thu, 04 Dec 2014 08:25:25 GMT

where i have to write this expression ?

sujeetsingh — Thu, 04 Dec 2014 08:28:41 GMT

In the Calender where you are using Quarter function and derieving the Quarter field, and using in the ListBox image, just use the expression

If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter

ch_riadh — Thu, 04 Dec 2014 09:13:15 GMT

Thanks