Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

null data display or how to handle

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

thanks

View solution in original post

6 Replies
tresesco
MVP
MVP

This blog should be helpful : NULL handling in QlikView

MK_QSL
MVP
MVP

Like this?

swuehl
MVP
MVP

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
Not applicable
Author

thank u

this is close

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

Anonymous
Not applicable
Author

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

thanks

Anonymous
Not applicable
Author

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