how to express Roundup function

[#1]

in excel when period = 201102，

Quarter(2011Q1)= LEFT(period,4)&"Q"&ROUNDUP(RIGHT(period,2)/3,0)

But Roundup function is not valid in Qlikview

so how can I change 201102 into 2011Q1 with Qlikview language?

[jonathandienst]

Hi

This should do it:

          LEFT(period, 4) & "Q" & CEIL(RIGHT(period, 2) / 3, 0)

Regards

Jonathan