Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Linking tables

Dear Experts;

I have a table containing the items info another containing customers info and a table for the transactions header and a table for transactions details.

If an item has no sales yet it is not appearing; once a transaction is done on an item it appears.

What should I do to see the item even if no transaction is done yet?

Thank you

Labels (1)
2 Replies
petter
Partner - Champion III
Partner - Champion III

The chart your are using will by default settings eliminate so-called null-values. This is what you get in your chart even if the dimension is not a null-value since the customer would be that - but there is no corresponding transaction value. What you have to do is to check/uncheck the right options in the chart properties on the presentation tab

Look for SUPPRESS MISSING and SUPPRESS ZERO-VALUES:

2015-10-21 #3.PNG

Anonymous
Not applicable
Author

for Dimension item you can define "Show all values"

does this solve your Problem?