Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
ch_riadh
Contributor

Quarter Function

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

But It  SHowed me :

   temp.png

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

Thank Guys.

1 Solution

Accepted Solutions

Re: Quarter Function

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

5 Replies
MVP
MVP

Re: Quarter Function

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

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

Re: Quarter Function

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
Contributor

Re: Quarter Function

where i have to write this expression ?

sujeetsingh
Honored Contributor III

Re: Quarter Function

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
Contributor

Re: Quarter Function

Thanks

Community Browser