Display Null Values

[#1]

Hi all,

I am displaying an histogram using an expression sum(column) and 2 dimension columns (risk level and bu_reporting).

For some rows the risk level is not filled ( empty cell), so in the histogram there is a sum(risk level) for rows with empty risk level=null.

I created a tab to display the selected part. for instance, when i click on a color (see attached), QV will display the list of rows relating to the selection.

My issue is when i am zooming by clicking on part of the bar where risk level=null, selected color will not display the rows related to this selection (no data to display in the tab) . Instead of this, it throwing me back to the whole histogram, as it has deleted all my selections

Can someone tell me was is causing this issue and how can i perform this action?

Regards

[nilesh_gangurde]

Heyy,

The qlikview will not allow you to select the null value in chart.

for this issue check out the data properly.

or you can supress the null value by selecting the "Supress when value is null" in the Dimension tab.

Regards,

Nilesh Gangurde

[gandalfgray · Accepted solution]

Hi

If you want to be able to select "Null" values you must really turn them into actual values in the load script.

One way to do it:

Right Join (YourTable)

Load *,

     if(IsNull(RISKREVSTAT),'No Data',RISKREVSTAT) As new_RISKREVSTAT

Resident YourTable;

Drop Field RISKREVSTAT;

Rename Field new_RISKREVSTAT to RISKREVSTAT;

// Now your NULL values will be replaced with a value 'No Data'

[#4]

Thank you Gandalf,

It worked fine!

I don't want to take too much of your time, so I know if i can submit you another issue that i am facing ??

Here is the issue explained below:

My purpose is to display at any point in time the actual turn over for projects. A project is represented by a row in a table (sourcetable) and if a project lasts the whole year i have 12 lines for the project. Some projects are closed within the year, and from the closing month they will not appear at all in the table for the subsequent months.

My issue is that for these closed projects  i am not able to display the turn over on a specific month(june for example assuming the project have closed in february). What i want in a such case, is to display the last non null turn over as the actual turnover (for this project june's turnover is the february's turnover!).

I have no challenge for the ones that are existing in the table, but for the ones that are not, i d'ont know how to deal with it to make them appear with the turnover !

I hope i have been clear enough

Thank you in advance

Best Regards