Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Creator II
Creator II

Line Chart - display prior year and year to date

Hello,

How do I make the "Year to Date" line stop at the most current month and not shoot downwards and display all those 0's?

Prior Year Expression: =(count(distinct{<[Scheduled Year] = {'2023'},[Exam Status] -= {'X'}>} [Accession Number]))

Year to Date Expression: =(count(distinct{<[Scheduled Year] = {'2024'},[Exam Status] -= {'X'}>} [Accession Number]))

 

drohm002_0-1720017317104.png

 

thank you for your help!

1 Reply
MatheusC
Specialist II
Specialist II

@drohm002 

In the chart properties under Presentation > change to Show as connctions / Show as gaps


MatheusC_0-1720027449643.png

 


- Matheus

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!