Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Remove label from chart

Hi guys,

I have a grid chart.

Could you help me to fix my aggregation expression for dimension to remove unlabeled tag?

Capture.JPG.jpg

If I remove aggregation from dimension, it works perfect.

Please find my attached file.

Thanks,

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Use this as your dimention

=if(aggr(count([Purchase Horizon])/count(TOTAL [Purchase Horizon]), [Purchase Horizon]) >0,

[Purchase Horizon]&'a ('&num((aggr(count([Purchase Horizon])/

count(TOTAL [Purchase Horizon]), [Purchase Horizon])),'#,##0%') &')')

View solution in original post

1 Reply
Clever_Anjos
Employee
Employee

Use this as your dimention

=if(aggr(count([Purchase Horizon])/count(TOTAL [Purchase Horizon]), [Purchase Horizon]) >0,

[Purchase Horizon]&'a ('&num((aggr(count([Purchase Horizon])/

count(TOTAL [Purchase Horizon]), [Purchase Horizon])),'#,##0%') &')')