Discussion board where members can get started with QlikView.
i am facing problems in concatenating two values
scenario: i have a date 6/30/2012, but i want to display it as Q2 2012
how can i do that?
i thought of concatenating Q2 with =year(today())-1, but it doesnt work
or can i use some variable, if so how?
pls assist me.
thanks in advance
Go to Solution.
expression: ='Q' & ceil(month(MyDate)/3) & ' ' & year(MyDate)
or in the script as a new field: 'Q' & ceil(month(MyDate)/3) & ' ' & year(MyDate) as Quarter
Suppose that your field name is myDt:
Let Quarter =
if(month(myDt)>=1 and month(myDt)<=3, 'Q1',
if(month(myDt)>=4 and month(myDt)<=6, 'Q2',
if(month(myDt)>=7 and month(myDt)<=9, 'Q3',
if(month(myDt)>=10 and month(myDt)<=12, 'Q4',
Your result will be :
$(Quarter) & text(year(myDt))
I would take Gysbert's expression and wrap the Dual() function around it, Then the values will get sorted correctly.
'Q' & ceil(month(MyDate)/3) & ' ' & year(MyDate),
) as Quarter
THanks &' '& worked !