Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
BrightFuture
Contributor III
Contributor III

Getting the quarters right using expressions in charts

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...

2 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Screenshot_2.jpg

It's not possible to reach your message.

Could you write down your issue please?

BrightFuture
Contributor III
Contributor III
Author

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 Smiley Happy

@MindaugasBacius