not display 0 with function above.

[#1]

Hello everybody,

In a bar chart, I suppress null value but when I used the function Above in the Decalage Bar, the bar "null' appears with a zero value...

How suppress this bar ?

Thanks for your help.

[Miguel_Angel_Baeyens]

Hi,

You are using ValueList() that is a syntetic dimension, so you are likely to need another condition (or set analysis) so if the value is zero, then do not print anything (show null, and as you are supressing nulls, it won't be displayed). But I don't see the above function in your app. What is the exact function do you want to use and where in the chart?

Hope that helps.

Miguel

[#3]

The function above is in the decalage bar in expression.

[#4]

Hi,

check the qvw attached.

Hope it helps

[Miguel_Angel_Baeyens]

Hi,

The expression in the chart should be this instead shouldn't it? Otherwise values in dimension will never match with condition in expression.

Sum(If(valuelist ( $(vtest) )=DimCountry,Sales))

Note that all calculated dimensions, If() conditionals and Count(DISTINCT) slow down the performance drastically. With a few records it will work just fine. With few thousands it will take too long to render. I'd better create the calculated dimension in the script.

Hope that helps.

Miguel