Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
MVP & Luminary
MVP & Luminary

Re: concatenating a string and expression output

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
5 Replies

Re: concatenating a string and expression output

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))

MVP & Luminary
MVP & Luminary

Re: concatenating a string and expression output

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

Re: concatenating a string and expression output

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

Re: concatenating a string and expression output

its perfect

points assigned

thanks

Not applicable

Re: concatenating a string and expression output

THanks &' '& worked !