Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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).