topic Grid Chart Label overlap using Dual Aggr() in QlikView

Grid Chart Label overlap using Dual Aggr()

shyamcharan — Sat, 16 Nov 2024 18:13:10 GMT

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 — Tue, 18 Aug 2020 08:58:26 GMT

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 — Tue, 18 Aug 2020 09:07:33 GMT

Thanks Alex. But i want to see the labels.

Brett_Bleess — Tue, 01 Sep 2020 15:55:34 GMT

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

Regards,
Brett