New to Qlik Analytics

If you’re new to Qlik Cloud or Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!

Who Me Too'd this solution

Or
MVP
MVP

Use Dual() to give each quarter its underlying date or numeric value. If you aren't tied to this specific format, Qlik has a built-in Quartername() function as well, but it won't match the format you're currently using.

From this specific format, you could probably do something like num(Right(Quarter,2) & left(Quarter,1)) for the numeric part of the dual(), but if you have the underlying date you could just use that.

View solution in original post

Who Me Too'd this solution