Grid Chart Label overlap using Dual Aggr()

[shyamcharan]

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. 

[alex00321]

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]

Thanks Alex. But i want to see the labels.

[Brett_Bleess]

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