null data display or how to handle

[Anonymous]

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

[tresesco]

This blog should be helpful : NULL handling in QlikView

[MK_QSL]

Like this?

[swuehl]

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]

thank u

this is close

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

[Anonymous · Accepted solution]

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

thanks

[Anonymous]

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