topic Re: Overlap chart line in QlikView

Overlap chart line

QSense — Fri, 16 Nov 2012 13:31:33 GMT

İ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

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?

Re: Overlap chart line

Clever_Anjos — Fri, 16 Nov 2012 13:52:16 GMT

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

Re: Overlap chart line

QSense — Fri, 16 Nov 2012 14:10:11 GMT

Actually It didn't make result exact different

Re: Overlap chart line

Clever_Anjos — Fri, 16 Nov 2012 15:32:08 GMT

So, try bigger values, like 0.05 or 0.5

Re: Overlap chart line

shree909 — Fri, 16 Nov 2012 15:39:58 GMT

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

can u unchek that..

Re: Overlap chart line

whiteline — Fri, 16 Nov 2012 18:34:53 GMT

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).