Hide label on qlik sense line chart

[Gin009]

Hi Guys，

On the line chart, you can only choose to show all data points label or not show label. Can you hide the labels from January to September? Only shows 10-12 months, or is there a better extension? except vizlib.

Thanks!!

[HirisH_V7]

What exact output you want to see?

[Lech_Miszkiewicz]

Hi @Gin009 ,

It depends how big your app is and how much workaround you are willing to put in without sacrificing performance. Below is actually quite straight forward.

In my example i just use dual() to change value representation to empty string. I dont know what will be criteria for you but you can come up with the statement which will be "true" for the dimension values where you would like to show labels.

Dual(If(Dim1<>'$(=MaxString(Dim1))','',num(Sum(Expression1),'#,##0')),Sum(Expression1)) 

Lastly - my advice is to stay away from extensions unless you are willing to do your work again when you upgrade Qlik Sense and your extension stops working for some reason. 

cheers

[Gin009]

Hi @HirisH_V7 

 The final output is like this：

The latest three months display the label value！

[Gin009]

Hi @Lech_Miszkiewicz 

 The final output is like this：

The latest three months display the label value！

[Lech_Miszkiewicz]

yeah - I know @Gin009 

So were you able to implement my solution with Dual()?

[Lech_Miszkiewicz · Accepted solution]

again - this is my example.

I have field called MonthYear which is properly loaded as:

Date(Floor(MonthStart(MyDateFiled)),'MMMYY')

I use that as a primary dimension on my chart

I also use Dim1 as secondary dimension

I use 1 Measure:

Dual(
If(floor(YearMonth) < $(=Floor(Max(Total YearMonth,3))),' ',num(Sum(Expression1),'#,##0')),
Sum(Expression1)
)

I use Number formatting: "Measure Expression"

here is a result:

do yo uneed anything else?

[Gin009]

Thank you for your support. After studying for an afternoon, I finally figured out this formula. Hahahaha😁, it is exactly the final result I want.👍