Collating Months in Quarters

[#1]

Hello All,

I have a number of tables which have been concatenated. I have then used the FileBaseName() function to retrieve the Excel filename and, thus, identify the month the data pertains to.

Would it be possible to organise this data into a quarter? If so, please let me know.

All the best,

Alison

P.S

If it's possible, please can provide a description of how the solution works as if I am just provided with the function, I find it difficult to understand how and why it works.

[#2]

Thanks for your answer.

I had tried to be clear in my initial post but I then become unsure of what question I should be asking, so sorry the lack of clarity.

The expression to generate month is working fine so thank you for that.

However, the Quarters expression is not working correctly. When in the UI the field generates no values.

Additionally, I would really appreciate it is you could explain the how the expression works as then, hopefully, I won't have to come back to you with the same issue in the future.

Nevertheless, thank you for all your help so far.

[#3]

Perhaps things got confused, sorry about that. As such I opened a new thread. Is it possible to close this one as it's not much use to anyone.

[sunny_talwar]

You can close this thread by marking this as a Assumed answer or you can mark one of the above responses as correct and/or helpful.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny