1 Reply Latest reply: Dec 13, 2012 1:17 AM by Jonathan Dienst RSS

    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?