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: 
drohm002
Creator
Creator

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
Specialist

@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!