topic Re: Case Statement in QlikSense in App Development

Case Statement in QlikSense

mhill176 — Thu, 04 Nov 2021 14:19:08 GMT

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 — Thu, 04 Nov 2021 14:22:07 GMT

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 — Thu, 04 Nov 2021 14:26:12 GMT

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