Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

want to pick Quarter from Date field

Hi,

My data is as follows

 

[Start Date][Exp End Date]
23/02/201531/07/2015
07/05/201513/05/2015
13/03/201515/04/2015
07/07/201515/07/2015
01/06/201529/06/2015
01/06/201522/06/2015
01/07/2015

15/07/2015

I have created  a list Box and wanted to pick Quarter field.

How can i do it with above information.

3 Replies
Gysbert_Wassenaar

='Q'& Ceil(Month(date#([Start Date],'DD/MM/YYYY'))/3)


talk is cheap, supply exceeds demand
maxgro
MVP
MVP

in the script you can create Quarter of start date and use in a listbox

load

     [Start Date],

     'Q' & ceil(month([Start Date])/3) as StartDateQuarter,

     ........

from

     yourtable

pratap6699
Creator
Creator

Load startdate,

'Q'& Ceil(Month(date#([Start Date],'DD/MM/YYYY'))/3) as Quarter

this is implement at script level