Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concatenating a string and expression output

HI all

         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

sujay

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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',

'ND'

)

)

)

);

Your result will be :

$(Quarter) & text(year(myDt))

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
hic
Former Employee
Former Employee

I would take Gysbert's expression and wrap the Dual() function around it, Then the values will get sorted correctly.

Dual(

          'Q' & ceil(month(MyDate)/3) & ' ' & year(MyDate),

          QuarterStart(MyDate)

          ) as Quarter

HIC

Not applicable
Author

its perfect

points assigned

thanks

Not applicable
Author

THanks &' '& worked !

abergheim
Contributor
Contributor

Try 

='Q2 ' & text(year(today())-1)