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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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!