Case Statement in QlikSense

[mhill176]

Hi,

I need a way to convert a YRMON string (ex. 202109 or 202005) into quarters.

So if Right(YRMON, 2)>9,4 should print '4' for any 4th quarter month - but I'm having trouble nesting the statements to mimic a CASE statement.

Any help would be appreciated,

Thanks.

[rubenmarin · Accepted solution]

Hi, you don't really need a case or nested if, to get the quarter you can use something like:

Ceil(Right(YRMON,2)/3)

[mhill176]

Perfect, this is exactly the kind of solution I was looking for! Thank you!