Problem with Gauge chart

[b737]

Hi,
I am presenting on Gauge chart percentage (%) of sold products, where default measure is [sales] with [period] as series for some [salesman] and I have calculation [percentage] which is calculating % of some planed sales and some other factors, and I show that as gauge needle.

Now I want when there is [sales] is null, which means that [%] is also null not 0 to hide chart. I have tried with option Properties - Set  the  No data Content Property to Yes , but the chart is steel there. Also I have tried with Boolean variable, queary1.[sales] is null, but it returning invalid expression.

Any help, please.

Thanks

[b737]

I have succeed to resolve this problem. I have used Conditional Style and when [%percentage] is null in Advanced Conditional Style I have checked Box Type to None and chart is hidden.

But now, I only want to retrieve massage ''NO DATA" or some interesting image with no data. How to do that, because when Box type is None all chart and it's propertis are hidden.   

[MFGF]

I have succeed to resolve this problem. I have used Conditional Style and when [%percentage] is null in Advanced Conditional Style I have checked Box Type to None and chart is hidden.

But now, I only want to retrieve massage ''NO DATA" or some interesting image with no data. How to do that, because when Box type is None all chart and it's propertis are hidden.

Sounds like you could use a conditional block instead of the "block type" = none property? Use the same condition for the conditional block as you are currently using and you should then have the option to add some text to the conditional block when the percentage is null.

Cheers!

MF.

[b737]

Can you pleas explain me how to do that. Did you mean that in Conditional Block apply Conditional style when [%percentage] is null, or what. What to do with chart and where to put text.

Thank you very much for your help

[MFGF]

Can you pleas explain me how to do that. Did you mean that in Conditional Block apply Conditional style when [%percentage] is null, or what. What to do with chart and where to put text.

Thank you very much for your help

Hi,

Drag in a conditional block from the toolbox. Apply the same expression you are currently using (ie sales is null) as the "Block Variable".

A conditional block will display different things based on whether your condition is true or false - the "Current Block" property allows you to switch between the true/false display options.

Set Current Block to No and drag your chart into the conditional block.
Set Current Block to Yes and drag your image/text into the conditional block.

Cheers!

MF.

[b737]

I am using DMR model, so like I said in my first post, when I put [%percentage] is null in variable expression definition returns error (invalid). I have tried that with Boolean variable. Do you mean that when you mentioned  "Block Variable" or what.

Thanks

[MFGF]

I am using DMR model, so like I said in my first post, when I put [%percentage] is null in variable expression definition returns error (invalid). I have tried that with Boolean variable. Do you mean that when you mentioned  "Block Variable" or what.

Thanks

Hi,

You told us you managed to get a valid expression in your conditional style when you were setting box type to none? Use the same approach in a variable driving the "Block Variable" property of your conditional block.

MF.

[b737]

Yes, it is working for Conditional Style but in Block variable it returnes invalid error like in this page https://www-304.ibm.com/support/docview.wss?uid=swg21339433

Now I am totally cofused how to do this in Gaugage chart. :'(


Thanks 

[MFGF]

Yes, it is working for Conditional Style but in Block variable it returnes invalid error like in this page https://www-304.ibm.com/support/docview.wss?uid=swg21339433

Now I am totally cofused how to do this in Gaugage chart. :'(


Thanks

As suggested in the IBM document you linked to above, you can try using the Properties property? Try selecting the value in Gauge Axes and going to the Properties property - add your percentage item in as a property and see if that fixes the issue.

Cheers!

MF.

[b737]

It works but does not hide empty chart, I have done everything with conditional bloks and variables, but chart is still on report  :(

[MFGF]

It works but does not hide empty chart, I have done everything with conditional bloks and variables, but chart is still on report  :(

Can you confirm that the chart is inside the conditional block?

MF.

[b737]

Yes, I have checked several times, all steps, but chart is still there :)

[MFGF]

Yes, I have checked several times, all steps, but chart is still there :)

In that case, it must mean the expression you are using for your conditional block is never evaluating to True? What items are in use in the gauge? You might need to create an item that delivers a tuple of the same value/member combo?

Cheers!

MF.

[b737]

I was on short holiday, so I did not have time to respond that I have succeeded. It need to put that whole page is from same query,and in that way is working. The only problem is that in that way you can have only one chart on page, or you have to create on query=one chart.

Thanks for help