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

How do you assign values to nulls ?

Hi,

I have data for many thousands of leads drawn into QV from Salesforce. For some of the leads, certain information is missing and the fields in salesforce have null values (literally, no value. a blank cell). For example, for the leads' marketing sources we have PPC, Media, WOM, Tradeshow, etc. and there are also many leads with just no value whatsoever.

When I create a chart in QV (for example a stacked bar chart) to show the number of leads generated per month from the different marketing source (the dimension are a time dimension and the marketing source, where the month of lead generation is the horizontal axis), the null leads do show in the stacked bar, but do not show in the legend whatsoever.

I tried to map the marketing source and assign "Unknown" to nulls (just created an excel file with the name of the marketing source on the left column and the name I want to see in QV on the column next to it), but that doesn't work. So, I'm turning to you guys. Any idea how to make it happen and have the null values appear in the legend as "Unknown" ?

Thanks!

44 Replies
Not applicable
Author

spoke too soon. it ONLY shows the unknown values now.

qlikpahadi07
Specialist
Specialist

Hi,

Still not done ? Did you tried my application ?

Not applicable
Author

no, because i still need the mapping for the other sources... thanks though

Not applicable
Author

Hi Al On,

may be your syntax isn't quite correct. Applymap() won't throw an error if it can't find the mappingtable accordingly.

So did you spell the name of your mapping table correct for example? In single quotes ?

RR

In doubt, you can post the code-snippets to check.

Not applicable
Author

Hi,

thanks for answering.

the problem was indeed with the mapping table name. I put it inside '[   ]' and that didn't work. After removing [] it does!