Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

how to express Roundup function

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?

Tags (1)
1 Reply
MVP
MVP

Re: how to express Roundup function

Hi

This should do it:

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

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser