topic Re: Getting the quarters right using expressions in charts in QlikView

Getting the quarters right using expressions in charts

BrightFuture — Thu, 24 Jan 2019 15:28:32 GMT

Hey everyone, could you please check this problem for me, I am sure it is not that difficult, but yet I could not solve it, maybe I am missing some necessary concept!

https://community.qlik.com/t5/QlikView-Creating-Analytics/Getting-the-quarters-right-using-expressio...

Re: Getting the quarters right using expressions in charts

MindaugasBacius — Thu, 24 Jan 2019 19:57:42 GMT

It's not possible to reach your message.

Could you write down your issue please?

Re: Getting the quarters right using expressions in charts

BrightFuture — Thu, 07 Feb 2019 13:55:25 GMT

Hey there,

I have accumulated data and need to get the quarters separated, I am using this expression in the Expression window. The dimensions are FY and Quarter. I am receiving different numbers although the logic is right. However I noticed that the code I write is for some reason not executed. So maybe someone has been in my situation before and has some answer.

I need to get the right data in the image (maybe if the first expression works!!!) but it does not right now!

Attached are some helping screenshots and source files to help you understand my problem and how the results should look like, you might need to change the directory according to yours

@MindaugasBacius