topic Re: Negative Values in Chart in QlikView

Negative Values in Chart

Thu, 07 May 2015 17:12:37 GMT

Hi All,

In application There are two dates eg-DATEA ,DATEB, Requirement is that DATEB-DATEA we did that fine in straight table,

but we are getting negative vaues in some cases, how negative values should show as 0 or dont show any value delete that record

Note:: should do in back end,plz i want logic for this

Re: Negative Values in Chart

Thu, 07 May 2015 17:56:25 GMT

Hi satish,

I need some clarification, Are you subtracting dates here?

If you clarify this I will try to post answer.

If my understanding is correct, You can find solution in attached .qvw.

Hope it helps you

Susvith

Re: Negative Values in Chart

MK_QSL — Thu, 07 May 2015 17:58:10 GMT

If((DATEB-DATEA) <0,0,(DATEB-DATEA) ) as FieldName

Re: Negative Values in Chart

maxgro — Thu, 07 May 2015 18:27:52 GMT

rangemax(0, DATEB-DATEA) as newfielddatediff

Re: Negative Values in Chart

Thu, 07 May 2015 19:52:27 GMT

hi,

requirement is dateA and dateB two dates if dateA-dateB(subtraction) then negative values are coming in chart they want to remove negative vale recors from application or change them to zero this shoulb be in back end

Re: Negative Values in Chart

Thu, 07 May 2015 19:56:13 GMT

Hi satish,

Then I guess I got it right. Did you check the qvw attached ?

Susvith

Re: Negative Values in Chart

Thu, 07 May 2015 20:06:35 GMT

Hi Susvith,

its working,thanku for your time.

Re: Negative Values in Chart

MarcoWedel — Thu, 07 May 2015 21:03:17 GMT

for Null values:

LOAD DATEB,
          DATEA,
          If(DATEB>=DATEA,DATEB-DATEA) as Days
FROM ...

regards

Marco