topic Re: null data display or how to handle in QlikView

null data display or how to handle

Anonymous — Fri, 18 Apr 2014 21:50:27 GMT

hi all

im asking for some advice on how to handle null data on qv.

we sell products and yearly we may sell some types and others years we may not.

we have a qv that tracks the difference of the product types sales between years.

simple example

2013

shoes 10

blouse 20

vest 4

2014

shoes 0

blouse 10

jeans 20

so there are two types of problems we encounter...

0 value sales and a product type that doesnt exist...

everytime we hit one of those.. the whole product type disappears since its in one yr but not the other..

not sure whats the best way of dealing with this.

thanks

tresB — Sat, 19 Apr 2014 06:22:16 GMT

This blog should be helpful : NULL handling in QlikView

MK_QSL — Sat, 19 Apr 2014 12:12:47 GMT

Like this?

swuehl — Sat, 19 Apr 2014 16:10:37 GMT

Or maybe like this for a year by year comparison.

You can also modify your data model, creating records with zero sales for missing products per year.

Anonymous — Mon, 21 Apr 2014 21:05:07 GMT

thank u

this is close

i need to see how to make it work... in my thing

Anonymous — Mon, 21 Apr 2014 21:05:39 GMT

this dimensionality works also i need to see how this works.. in my script..

thanks

Anonymous — Mon, 21 Apr 2014 21:06:23 GMT

i saw this pdf before... i couldnt get it to work with the season example i saw...

or my understand of the expressions isnt so great.

thanks