Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
It seems correct can you share app or you can do some change in the load script
If( Len( 'Q' & Ceil (Month(Month)/3) >1, 'Q' & Ceil (Month(Month)/3) ) as Quarter
Instead of using FieldName Quarter in List box use expression and use below
where i have to write this expression ?
In the Calender where you are using Quarter function and derieving the Quarter field, and using in the ListBox image, just use the expression