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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

Overlap chart line

İn my chart ,

I have two expression

one of them is quantity of request opening date more than 30 days : =Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2) 1 aydan uzun süredir Açık İstek Adedi

other expression is only quantity of requests : count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM)) Açık İstek Adedi

istek.png

but in chart "açık istek adedi" (Blue one)expression is shown for only 30 days How can I make it show through all dates like red expression

How can I seperate these two lines?

5 Replies
Clever_Anjos
Employee
Employee

Well, there´s a simple and "dirty" way.

Just add 0.0001 (or very small) value to one of your expressions

count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM)) + 0.0001

QSense
Creator II
Creator II
Author

Actually It didn't make result exact different

Clever_Anjos
Employee
Employee

So, try bigger values, like 0.05 or 0.5

shree909
Partner - Specialist II
Partner - Specialist II

in the presentation tab of chart have u suprresed the zero values?

can u unchek that..

whiteline
Master II
Master II

Hi.

QV shows values only if they exist. If you don't have data for that periods you have to add them in a script (even if you want just zero values).