Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
shyamcharan
Creator III
Creator III

Grid Chart Label overlap using Dual Aggr()

Hi Experts,

I am trying to display values on data points using the Grid chart.

I have seen a post on this forum and used Dual(Aggr()) functions to display the labels.

However, the labels overlap. The aggregation should happen over four levels in time period hierarchy. Year, Month, Day and hour.

I could not get it worked and seeking you help here.

Attached is the sample qvw with data.

Thanks in advance. 

Labels (1)
3 Replies
alex00321
Creator II
Creator II

Hi I think this is correct based on your formula. If you don't want to see the overlapped words, please see if attached file works. Thanks!

shyamcharan
Creator III
Creator III
Author

Thanks Alex. But i want to see the labels.

Brett_Bleess
Former Employee
Former Employee

Not sure if this will be helpful or not, but will let you decide:

https://community.qlik.com/t5/Qlik-Design-Blog/Dual-Exists-Useful-Functions/ba-p/1465290

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.