Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Gin009
Contributor III
Contributor III

How to display label values for part of the month in a Qlik Sense line chart?

Hi guys,

How to display label values for certain months in a line chart in Qlik Sense instead of displaying label values for all months. Is there any other way besides vizlib tables, or are there any other free Extensions?

Currently designed with Qlik sense:

Gin009_0-1715679873965.png

 

final design:

Gin009_1-1715680029851.png

 

Labels (1)
1 Reply
MeehyeOh
Partner - Creator
Partner - Creator

Hi, @Gin009 

 

Try the "Dual" function and set the number formatting to "measure expression".

  • Measure expression(In my case)
    : If(YM>= '$(=Date(Monthstart(AddMonths(Today(),-3)),'YYYY0MM'))' and YM <= '$(=Date(Monthstart(Today()),'YYYY0MM'))'
    ,Dual(Num(Sum(Value),'#,##0'),Sum(Value))
    ,Dual(' ',Sum(Value))

 

MeehyeOh_0-1716443243941.png

Reply, thanks!