topic Re: 0 instead of - in QlikView

0 instead of -

francisvandergr — Wed, 12 Oct 2011 12:24:49 GMT

I have a qvw with a table and some fields. In my datamodel i wanna have a sum from some fields. I have an example

Project\Nummer 11000 has in the column Budget an '-' . In the column Total i wanna have -2220.38

I wanna have 0 as number instead of - in my table.

Can someone help me. I included an QVW file

0 instead of -

swuehl — Wed, 12 Oct 2011 13:01:27 GMT

Francis,

as far as I see, you removed the data and objects from your qvw, so I can't see actual numbers (and I can't reload of course).

As far as I have seen in your script you played around with NullAsValue etc. which might be the solution.

I remember there were some issues with using that on a concatenate load, please check this:

http://community.qlik.com/message/137850

Hope this helps,

Stefan

0 instead of -

SunilChauhan — Wed, 12 Oct 2011 13:07:28 GMT

sum(if( isnull(Budget),0,Budget))

or in script where Budget field available use this

if( isnull(Budget),0,Budget))

0 instead of -

francisvandergr — Wed, 12 Oct 2011 13:16:42 GMT

Sorry but this will not help. I still see a '-' at a lot of records

0 instead of -

francisvandergr — Wed, 12 Oct 2011 13:18:37 GMT

you can see the data with ctrl-t

0 instead of -

SunilChauhan — Wed, 12 Oct 2011 13:19:29 GMT

can u share the sample .

you have attached the file which not reloaded .can u reload and share?

Re: 0 instead of -

francisvandergr — Wed, 12 Oct 2011 13:32:36 GMT

Her i have another example. In QV on the dashboard it goes good. When i do sum(Budget-Costs). When i do this in my datamodel Sum(Budget-Costs) it goes wrong.

And the problem is i have to count in my datamodel.

Re: 0 instead of -

SunilChauhan — Wed, 12 Oct 2011 13:38:49 GMT

see the attached file

hope this helps

Re: 0 instead of -

francisvandergr — Wed, 12 Oct 2011 13:58:23 GMT

In dashboard it goes good but not in datamodel see Total.

0 instead of -

SunilChauhan — Wed, 12 Oct 2011 14:16:40 GMT

ok you need to check total field in script

weither calculation are correct.

0 instead of -

Wed, 12 Oct 2011 16:02:48 GMT

I would go to presentation tab of chart properties and replace NULL NUMBER value

change option to '0' by replacing '-'

Re: 0 instead of -

swuehl — Wed, 12 Oct 2011 16:57:07 GMT

Hi Francis,

since I can't reload, I used a binary load of your qvw and a resident load of your table.

E voilá, it seems to work without any other change.

Strange.

Stefan

Re: 0 instead of -

francisvandergr — Wed, 12 Oct 2011 20:37:27 GMT

Thanx all for help. In my script i stored the table first in a QVD and when i load it back it works.

indeed strange