Disregard the null values in expression with dimension limits

[Anonymous]

Hi,

I have a table,

LOAD * INLINE [

    Country, Sales, Profit

    USA, 10000, 2000

    UK, 9000, 1000

    FRANCE, -, -

    INDIA, 30000, 4000

    PAKISTAN, 3000, 5500

];

Now, i have created a bar chart, with country dimension and sum(sales)/sum(Profit) as expression. I gave the dimension limits to show largest 4 (Uncheck the Show Others option). Now, as France has no values in the sales and profits, i don't need FRANCE to appear in the chart (so, i check the Supress Zero Values option in presentation), instead i need the next country, that is PAKISTAN to appear as 4th bar, when i sort the chart by y value descending.

Any suggestions?

I want the expression to disregard the null values while evaluating the expression for this. Thoughts?

[Anonymous]

Here is the sample app

[hic]

You need to post some data. If I load your data and create your bar chart, I get this at first try

France is automatically removed. And that's what you want, or...

HIC

[Anonymous]

I used the dimension limitations, to show the largest 4 and uncheck the others. Then it is giving only first 3 bars.

[#5]

Here it is...!

[Anonymous]

If i have some more data like the below:

LOAD * INLINE [

    Country, Sales, Profit

    USA, 10000, 2000

    UK, 9000, 1000

    FRANCE, -, -

    GERMANY,  2500, 2500

    INDIA, 30000, 4000

    PAKISTAN, 3000, 5500

];

Now i get 0 for GERMANY Sum(Sales)-Sum(Profit) too. So, i need this to appear in the chart as 0 on bar. But, as France doesnot have the data, i don't need France to appear in the chart.

In this case, if we give if(expression<>0, expression), i will miss Germany. I need Germany and don't need France

[#7]

Here it is....!

[#8]

Here...!

use 'Set NullInterpret = -;

[suheshreddy]

Here it is